Boolean formula for Conditional Formatting
 

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.

Boolean formula for Conditional Formatting
 

Arthur,

Try a formula like

=AND(D5<0,C5=9)


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



"Arthur" wrote in message
...
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.

Boolean formula for Conditional Formatting
 

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

"Arthur" wrote:

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.