View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
apache007 apache007 is offline
external usenet poster
 
Posts: 36
Default 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.