Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2006

Tip: Looking for answers? Try searching our database.

Conditional Formatting help...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
J144 - 29 Mar 2006 22:27 GMT
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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.