Conditional Formatting a cell based on the adjacent cell being blank

[donbot97]

I want to highlight a cell as white (no fill) if the cell contains a number and the cell to the left of is blank - how can I achieve this using conditional formatting? Currently with my other rules, it will appear as red if the adjacent cell to the blank one contains a value.

I currently have 3 rules in this worksheet:
- Highlight red if d2>c2
- Highlight green if d2 < c2
- Highlight grey if blank

 

[EFANYoutube]

Hi Donbot

If you highlight one cell you want to be affected by the conditional formatting and in the conditional formatting you put in this
=AND(E2<>"",D2="")
(I highlighted E2){ take away the $ signs, very important)
Then use the format painter to update al thecells you want to be affected

Hope this helps

Excel Fun

 

[donbot97]

Hi EFANY,

Yes this works perfectly, thank you so much!

 

[Kelley303]

Hi Donbot

If you highlight one cell you want to be affected by the conditional formatting and in the conditional formatting you put in this
=AND(E2<>"",D2="")
(I highlighted E2){ take away the $ signs, very important)
Then use the format painter to update al thecells you want to be affected

Hope this helps

Excel Fun

I wonder if you can also help me....

I am trying to put some conditional formatting on column H in my spreadsheet.

I want it to work like this: Cell H7 should turn Red if the cell to the left, G7 is blank. I am able to do this, however I want it to work all the way down the column... so H8 should turn red if G8 is blank. For some reason the entire column is turning red - I want the formatting to work like a regular formula would, with each cell in column H reading the cell to the left in column G.

Are you able to help me with this? I would appreciate it so much!

 

[Kelley303]

Hi Donbot

If you highlight one cell you want to be affected by the conditional formatting and in the conditional formatting you put in this
=AND(E2<>"",D2="")
(I highlighted E2){ take away the $ signs, very important)
Then use the format painter to update al thecells you want to be affected

Hope this helps

Excel Fun

You know what, I just got it to work. I guess I had to break down and ask someone.