hi oOLILYOo, welcome to the forum. assuming your data is from A2:F10 & dates "last updated" is in column F, highlight them & go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
Green:
Repeat the above steps again & do these formulas for orange & red.
Orange:
Red:
also, your green & orange kind of overlapped. last 30 days & 30-90. so i changed the orange to 31-90.
if it still can't work somehow, do upload a sample for us. press "Go Advanced" beside the "Post Quick Reply" & click on the paperclip icon
Bookmarks