Color third cell if cell 1 is filled, and cell 2 is not

[Enounce]

Hi,

I'm trying to make a simple overview to see if translations are done.

I would like to color the third cell if cell 1 is filled, and cell 2 is not. It's enough that the cell which is missing is being highlighted red. I don't necessarily need cells which are done to be highlighted green. I hope the example will illustrate it better than I can explain it.

Thanks for your help.

[AliGW]

You cannot change the status of one cell based on the colour of another without VBA. Shall I move the thread for you?

EDIT: Having now looked at your workbook, I really can’t decide what it is you are trying to do!

[FDibbins]

Ali, I was just looking at this 1. I think OP wants to add color to a cell, so it would (I think) need CF for this? (I could be totally off the mark here, I have been before lol)

[AliGW]

See my edit - the workbook doesn’t seem to match the description above. Confused!

[Fluff13]

You were almost there, it should be
=IF($E2<>"",$F2="")

[mikeava]

Will 1st column always contain data?

[mikeava]

After playing around with it I think I came up with solution with Conditional Formatting

Highlight 3rd Column (Column C)
In Home tab click on Conditional Formatting
Click on New Rule
Click on Use a formula to determine which cells to format
In Format values where the formula is true box type =$b2:$b99<>""
Next to Preview box click Format
Click on Fill
Select Green color
Click on OK then OK

Highlight 3rd Column (Column C)
In Home tab click on Conditional Formatting
Click on New Rule
Click on Use a formula to determine which cells to format
In Format values where the formula is true box type =isblank($b2:$b99)
Next to Preview box click Format
Click on Fill
Select Red color
Click on OK then OK

[Enounce]

Thanks guys for all your input.

I included all your solutions, but I am not quite there yet, but close!

It need to be based on if there is something typed in the first row, much like Fluff13's solution. BUT now I was wondering if it could be highlighted only in the missing cell itself?

uRXRzIM.png

[Croweater]

So just remove the conditional formatting that Fluff13 put in column E (and obviously leave the conditional formatting in for column F)?

[Enounce]

I should have figured. Thanks, Croweater. Thanks all.

[Fluff13]

You're welcome & thanks for the feedback.