Conditional Formatting help...

[J144]

This is a followup question to one I posted a few days ago with the
title "How to change cell color based on content". Someone had
recommended I use "Conditional Formatting." So, I tried but it didn't
work out the way I expected.

Here's what I did:

New spreadsheet
in cell A1: Check
in cell B1: 100
Select cell B1
Menu select Format/Conditional Formatting...
Left combo, select "Formula Is"
In formula box: =(B1 > 0) & (A1 = "Check")
Click on Format button
Click on Patterns tab
Click on the red color
Click on OK
Click on OK (in Conditional Formatting dialog)

But Cell B1 did not change appearance

I expected it would change cell B1 to a red background.

What am I doing wrong?

Thanks,
J

 

[Bob Phillips]

Try

=AND(B1>0,A1="Check")


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

Highlight both cells if you want them to change colour.Then replace your
conditional formatting formula with =AND($B$1>0, $A$1="Check")

 

[J144]

=AND(B1>0,A1="Check")

Thank you, this works!