Conditional formatting formula for when 1 cell if blank _and_ another cell is not?

[StargateFanNotAtHome]

I know how to do conditions all by themselves. In this case, if J2 is
blank I'm using this to set the cond form for the cells K2 and L2,
respectively:

=(ISBLANK($J2))

But I've never used 2 conditions about 2 different cells. If J2 is
blank but B2 is not blank, _then_ is when the cond form should take
place.

The 2nd condition by itself would be something like this:

=NOT(ISBLANK($D2))

But I don't know how to put the 2 together.

Thank you! D

 

[Rick Rothstein \(MVP - VB\)]

Try this...

=AND(ISBLANK($J2),NOT(ISBLANK($D2)))

Rick

 

[StargateFanNotAtHome]

Try this...

=AND(ISBLANK($J2),NOT(ISBLANK($D2)))

Phew, seems to work just great.

Dang, when am I ever going to get the hang of mixing things together.
The more I do, I guess.

Well, this is another one for my tips file.

Thanks! D