Boolean formula for Conditional Formatting

[Guest]

I'd like cell D5 to turn red if it is a negative value and cell C5 has a
value of 9. How do I set this up? I've tried entering a boolean formula such
as ...

+d5<0 #and# +c5=9

But Excel doesn't seem to recognize #and#.

I tried entering the second part of the formula as a second condition, but
that seems to be if you want the cell format to have multiple possible
outcomes.

 

[Chip Pearson]

Arthur,

Try a formula like

=AND(D5<0,C5=9)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Guest]

I found the answer in an 8/25 post:
and(condition1,condition2)