View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gurmeet Singh Gurmeet Singh is offline
external usenet poster
 
Posts: 1
Default content coloring

I need some help to figure out how to color text based on
some conditions.

In column C of my excel sheet I have planned date and in
column D I have actual start date. I have similar type
of information in column G and H. I have entries in
these columns for rows 1 to 147. Also, we enter data in
these cells manually and they change on daily basis.

I would like color of date in a column D to go red
whenever it is greater than the date in column C for any
row. Similarly color of date in column H should go red
whenever it is greate than column G for any row.

If you have ideas on how to dothis, please do let me know.

Thanks for your help in advance.

Regards,
.....gurmeet