Hello,
I currently have this wonderful code that color codes cells based on the due date and the actual date. However, we are now chaging this to be a due date and a checkbox if the appointment was scheduled. I would like cells to be color coded based on the following.
Green - Checkbox checked (due date any time)
Yellow - Due date upcoming (and the checkbox isn't checked)
Red - Due date is in the past (and the checkbox isn't checked)
Could someone please help me modifiy this code?
var text red = "<a style=\" text-decoration: none; background: #ea4335; border-radius: 5px; color: #fff; display: inline-block; width: 160px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&ToText(ToDays(Today()-[Appointment Needed By]))&" Days Overdue</a>";
var text green = "<a style=\" text-decoration: none; background: #34a853; border-radius: 5px; color: #fff; display: inline-block; width: 160px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">Complete</a>";
var text yellow = "<a style=\" text-decoration: none; background: #fbbc05; border-radius: 5px; color: #fff; display: inline-block; width: 160px; text-align: center; padding: 8px 20px; font: normal 700 14px/1 \"Calibri\", sans-serif; text-shadow: none; \">"&ToDays(Today()-[Appointment Needed By])&" Days Due</a>";
If(not(IsNull([Scheduled - Yes])),$green,
If(IsNull([Scheduled - Yes]) and [Appointment Needed By] >= Today(),$yellow,
If(IsNull([Scheduled - Yes]) and [Appointment Needed By] < Today(),$red)))
THANK YOU!
------------------------------
Meagan McOlin
------------------------------
