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 / September 2006

Tip: Looking for answers? Try searching our database.

Conditional formatting - compound condition

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Eric - 30 Sep 2006 16:47 GMT
I'm trying to do something that seems like it should be simple.

In Cell A10, I want conditional formatting that says:  if Cell A10 is not
blank AND Cell C5 = 1, then apply conditional formatting.

I can use the Cell Value Is for the A10 check (applying one format), and the
Formula Is option for the C5 check (applying another format).  But I can't
combine them so that I do the two checks and if they're BOTH true, apply a
formula.

If I try to use the Formula Is option with a cell that references both
cells, I get a circular reference, which Excel doesn't like.  (I.e., Cell A10
with conditional formatting using a formula which references A10 itself.)

Any suggestions?
Thanks.
Trevor Shuttleworth - 30 Sep 2006 17:31 GMT
Conditional formatting

Formula is:    =AND($A$10<>"",$C$5=1)    apply format

If you need this in other cells you may need to move the absolute references

Regards

Trevor

> I'm trying to do something that seems like it should be simple.
>
[quoted text clipped - 14 lines]
> Any suggestions?
> Thanks.
 
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



©2010 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.