Conditional formatting for how overdue something is

Robb Parris

Hi all

 

I am trying to use conditional formatting to change the colour of the date cell for when the date cell is over a week ago, and then another color for when the date cell is over a month ago.

 

I think I may be missing something!

 

So in effect, the cell would be normal when under 7 days overdue, when 7 days overdue it changes to one colour, then it changes to another colour when reaching 30 days overdue.

 

I was able to do this in google docs, but unsure how to do it here!

 

Thanks for any help you can give me!

 

 

Ichiorochi

Hello Robb,

 

My advice to you would be to first greate a Date column if you do not already have one, then under condition you can now pick the date column and say "is in the last (7/30) days" and go from there.

 

Hope it helps!