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

  • Thread starter StargateFanFromWork
  • 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! :eek:D
 
R

Rick Rothstein \(MVP - VB\)

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
 
S

StargateFanFromWork

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))

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! :eek:D
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top