CONDITIONAL FORMAT BASED ON 2 CELLS

S

Steve_n_KC

Even to me this seems like it should be simple but I'm not able to make it
work:

Given A6:L6, I would like B6 through L6 (independent of each other) to be
shaded red IF A6 contains any value AND the 2nd cell is blank. If A6 is
blank OR second cell contains any value then no shading.
 
D

Denis J.

Use an IF((isblank),1,0) Using conditional formatting 1 = Red
However, conditional formatting refers to a value in its current cell. A1 =
0 and B1 = 1, c1 is blank. Even though B1 has a value of 1, C1 will not be
RED as its cell value is blank.
 
S

Steve_n_KC

A half day problem solved in under 13 minutes! Thanks so much! (I had to
pull a couple $'s out for copying purposes but You got me where I needed to
go!)
--
THANKS!

Steve


PCLIVE said:
Use this for FormulaIs:

=AND($A$6<>"",$B$6="")

HTH,
Paul
Click to expand...
 
P

PCLIVE

No problem. Thanks for the feedback.


Steve_n_KC said:
A half day problem solved in under 13 minutes! Thanks so much! (I had to
pull a couple $'s out for copying purposes but You got me where I needed
to
go!)
Click to expand...
 
Top