Conditional Formatting
Hi All,
I need help on conditional Formatting.
I have a column of data with future DATE, such as 2 Jan 09, 4 Des 09, etc
I would like to assign automatically different colors to those data that
match these condition:
If (TODAY's date < Data's date) And more than 30 days, COLOUR is Orange
If (TODAY's date < Data's date) And more than 60 days, COLOUR is Yellow
If (TODAY's date < Data's date) And more than 90 days, COLOUR is Green
If (TODAY's date = Data's date) And more than 30 days, COLOUR is Red
I would like to gave it AUTOMATIC, such that if I put a date, it will adjust
the colour byitself in that instant.
I apperciate the help.
|