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)

"J144" <nospam@nospam.com> wrote in message
news:Oqa0ne3UGHA.2492@TK2MSFTNGP11.phx.gbl...
> 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

[MarkN]

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

--
hope this helps,
MarkN


"J144" wrote:

> 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
>

[J144]

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

Thank you, this works!