Conditional formatting

[Opgelost]

Dear all,

Can you please help me with the following:

I would like to highlight the CELL in COLUMN C if the corresponding CELL in COLUMN D is empty.

Kindly advise.

Kind regards,

Opgelost

 

[Joe4]

For cell C2, select cell C2, go to Conditional Formatting and use the following Conditional Formatting formula:

=D2=""

and choose your highlighting color.

 

[Opgelost]

Dear Joe4,

Thanks but it doesnt work. I work with excel 2016.

Thanks.

 

[Joe4]

If your cell is really blank, it should work.
Are you sure that there isn't something in there, like a space?

Are you selecting just one cell when you apply it, or a whole range?
Note that if you are selecting a whole range (like the whole column), you NEED to write the CF formula as it applies to the very FIRST cell in your selected range.
So, in that case you would use the formula:

=D1=""

If you still cannot get it to work, please explain your exact steps.

 

[Opgelost]

Great, it works! Thanks!

if your cell is really blank, it should work.
Are you sure that there isn't something in there, like a space?

Are you selecting just one cell when you apply it, or a whole range?
Note that if you are selecting a whole range (like the whole column), you need to write the cf formula as it applies to the very first cell in your selected range.
So, in that case you would use the formula:

=d1=""

if you still cannot get it to work, please explain your exact steps.