Conditional Formatting to change cell color based on value of two cells

[ediancoc]

I need a formula to conditional format Cell B2 when something is selected in Cell A2. I am using a Vlookup Formula to pull information in column B when selecting data in Column A. so if data in column A has value on column B, it should stays the same. if data on column A has no value attached on column B then I need the cell B2 to change color.

Column A Column B[TABLE="width: 210"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
1 ******* $50
2 Bathroom -
3
Thank you

 

[Jeffrey Mahoney]

Highlight the data in column B and make a formula based Conditional Format (CF). For the formula:
=AND($B1="",$A1<>"")
Change the cell to whatever color you thinks is cool at the time.

Jeff

 

[ediancoc]

Thank you Jeffrey.
When I test the formula with true and false it wokts, but I don't know why when I enter the formula into the conditional formatting the cell won't change color. Any advice?

 

[Jeffrey Mahoney]

Sorry, but I have to ask. Did you click the "Format" button and choose a fill color inside the CF window?