Try this...

Select cell J6
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A6=""
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"Kevin" wrote in message
...
How do I do a conditional format saying that if A6 has nothing in it then
turn J6 a certain colour.