A
apache007
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.
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.