Conditional Format
 

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

Conditional Format
 

Hi,
position in cell J6, conditional formating, where the formula is enter

a6="" and choose your color

"Kevin" wrote:

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

Conditional Format
 

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.