Highlight Row 7
Select Conditional Formatting from the Format menu

Condition 1: Formula Is: =NOT(ISBLANK($E7))
Colour = Green
Condition 2: Formula Is: =NOT(ISBLANK($D7))
Colour = Yellow
Condition 3: Formula Is: =NOT(ISBLANK($C7))
Colour = Light Blue


You'll need to use VBA to get any more Conditional Formats than three.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Andos" wrote in message
...
Is there a method whereby I can have a input a date in a cell and it will
automatically change the row colour? I am tracking a workflow process.

For example,
if I input a date into cell C7, then row 7 would change all cells to be
colour 'LIGHT BLUE'.
if I then, input a date into cell D7, then row 7 would change all cells to
be colour 'YELLOW'.
if I then, input a date into cell E7, then row 7 would change all cells to
be colour 'GREEN'.
etc, etc...

Any ideas on the best way to do this?