Hello,I am really struggling trying to figure out how to create a formula. I have done so much research on and it is already an area I struggle in.
I am trying to create a formula that will highlight the rows in a report a color depending on how overdue they are.
e.g. less than 30 days is no background color30-59 days overdue would be yellow60-89 days overdue would be green90 days and over would be red.
Can you please help me with this?
What is your current formula?
Your color code formula should look something like this:
If([Days Past Due]<30,null,
If([Day Past Due]>=30 or [Day Past Due]<60, "Yellow",
If([Day Past Due]>=60 or [Day Past Due]<90, "Green","Red")))