content coloring

  • Thread starter Thread starter Gurmeet Singh
  • Start date Start date
G

Gurmeet Singh

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
 
Gurmeet,
Conditional formatting should help you do all of this.
Look in your Excel Help file, or otherwise use the
conditional format dialog box under the Format menu. This
should be very straight forward.
Good luck!
Dominic.
 
Back
Top