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 / December 2007

Tip: Looking for answers? Try searching our database.

If B1 is not empty but B2 is ... conditional formatting "formula"?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
StargateFanFromWork - 20 Dec 2007 22:41 GMT
I've set up a sheet that works great _except_ if B1 has a value in it but B2
doesn't.  I've set up conditional formatting.

When B1 is empty, no colour or font attributes in cells B3 to B14.  Good.

If B1 does have a value in it, the cell colour and font attributes in B3 to
B14 are the same as if B1 was not empty but B2 was also not empty.

I'd like to differentiate between the 2 in conditional formatting.  If B1 is
not empty yet B2 is, that will be my 3rd conditional formatting.  However,
nothing I've tried works.

Here's what I have now ...
Cond Form #1:  =NOT(ISBLANK($B$1))
Cond Form #2:  ==(ISBLANK($B$1))

Thanks for any help!  :oD
Rick Rothstein (MVP - VB) - 20 Dec 2007 22:57 GMT
I got it to work using these conditions in this order...

Cond #1:   =AND(NOT(ISBLANK($B$1)),NOT(ISBLANK($B$2)))
Cond #2:   =NOT(ISBLANK($B$1))
Cond #3:   =NOT(ISBLANK($B$2))

Rick

> I've set up a sheet that works great _except_ if B1 has a value in it but
> B2 doesn't.  I've set up conditional formatting.
[quoted text clipped - 13 lines]
>
> Thanks for any help!  :oD
StargateFanFromWork - 21 Dec 2007 17:50 GMT
>I got it to work using these conditions in this order...
>
> Cond #1:   =AND(NOT(ISBLANK($B$1)),NOT(ISBLANK($B$2)))
> Cond #2:   =NOT(ISBLANK($B$1))
> Cond #3:   =NOT(ISBLANK($B$2))

Wow, thanks!  That's what I was missing, the syntax for putting 2 conditions
together.

I played around with this for other cells than those described here that
depended on B1 and B2.  And I made the change to all the affected cells.

Seems to be working perfectly!

Cheers!  :oD

> Rick
>
[quoted text clipped - 15 lines]
>>
>> Thanks for any help!  :oD
 
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.