Conditional formating if the cell is empty.

[Jagdev]

Hi Experts
I am looking for a conditional formatting formula for the below criteria.
Say if there is a value in column A cell A1, then if any cell say B1, C1 and D1 contains empty cell, it should change the color of that empty cell.
Regards,
JD

[p45cal]

Select say B2:D1000 (change the 1000 to your range)
The active cell should be B2, this is important.
Then while the above range is selected: Home tab, conditional formatting, New Rule…, Use a Formula to determine which cells to format then copy this formula:
=AND(NOT(ISBLANK($A2)),ISBLANK(B2))
Choose your format, click OK.

[Jagdev]

Hi p75cal

Thanks for the code.. I find another one which fits into the requirement as well \

"=and(B2="",$A2<>"")"

Regards,
JD