Changing cell colors in a row IF...
 

You can use conditional formatting to colour the cells if the cell in
the complete date column contains a value. For example, if Complete date
is in column B:

Select cells A2:AK2
Choose FormatConditional Formatting
From the first dropdown, choose Formula Is
In the formula box, enter a formula that refers to the Complete Date
cell in the active row:
=$B2<""
Click the Format button, and on the Patterns tab, select a colour
Click OK, click OK

There's an example he

http://www.contextures.com/xlCondFormat02.html

Mr. Dan wrote:
I have 300+ rows of data. I'd like to change the cell color of a row (or,
more specifically, columns A through AK) when a complete date is entered into
a cell in that row.

Thanks in advance!!!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html