Hi All,
Would anyone know how to?
In Excel I want the date to turn red in a column by its self one month before that date I.E. todays date 15-11-07
Date due
15-12-07
Sorry the table will not work on here, what I am trying to do is a servicing table, so if you open the table the ones that turn red are due for service.
Anyone know how to do this?
Thank you
MM
Would anyone know how to?
In Excel I want the date to turn red in a column by its self one month before that date I.E. todays date 15-11-07
Date due
15-12-07
Sorry the table will not work on here, what I am trying to do is a servicing table, so if you open the table the ones that turn red are due for service.
Anyone know how to do this?
Thank you
MM