Conditional format - AND statement

Gurus,

I am trying to conditional format a cell based on if that cell is blank AND another cell is not blank. Can I do this via a whole column or do I need to conditional format each cell individually?


My current formula is:

Please Login or Register  to view this content.

but its not working.

Wanted results:
if b13 is not blank and ab13 is blank then AB13 fills to gray

The range AB13:AB52 is to follow this condition.

Suggestions?


TIA,
Tim

Please Login or Register  to view this content.

BMV,

This works... I was thinking that the range needed to be in the formula but it only needs to be in the Applied To box.

Thanks for your help.

Tim