Prev: how can i alphabetize footers in excel?
Next: Want to add a dot in between to Names
From: apache007 on 1 Feb 2010 23:42
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.

 | 
Pages: 1
Prev: how can i alphabetize footers in excel?
Next: Want to add a dot in between to Names