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