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

  • Thread starter Thread starter StargateFanFromWork
  • Start date Start date
S

StargateFanFromWork

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
 
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
 
Rick Rothstein (MVP - VB) said:
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))
Click to expand...

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