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 - 29 Mar 2006 22:32 GMT
Try
=AND(B1>0,A1="Check")
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
> 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
[quoted text clipped - 24 lines]
> Thanks,
> J
MarkN - 29 Mar 2006 22:42 GMT
Highlight both cells if you want them to change colour.Then replace your
conditional formatting formula with =AND($B$1>0, $A$1="Check")

Signature
hope this helps,
MarkN
> 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
[quoted text clipped - 24 lines]
> Thanks,
> J
J144 - 29 Mar 2006 23:09 GMT
> =AND(B1>0,A1="Check")
Thank you, this works!