Flagging up dates in cells

  • Thread starter Thread starter midase
  • Start date Start date
M

midase

I need help on how to automatically flag up or highlight a date in
cell 30 days prior to reaching that date.

e.g If an instrument needs calibrating on the date in the cell I nee
to be warned 30 days prior to make arrangements. The warning would b
the date changing colour, (Red) for example.

Would be grateful for some help
 
Use conditional formatting

Format, Conditional Formatting,
Cell Value Is, Less than or equal to, =Now()+30

Then set the format options you want


On further thought it might be worth using
Cell Value is, Between, =Now(), And, =Now()+30
because this will reset the format to normal when the due date i
passed
 
Back
Top