Conditional Formatting

[Millevz]

Hello
I would like to create a conditional format within my table in Excel. I have found that the people completing the data are missing certain columns when entering a new row.

I would like the table row to highlight yellow once a new employee ID has been entered and then the cells return to 'no fill' once they have been completed.

I can manage to get the row to highlight but I am struggling with making the highlighting vanish once the cell is completed.

Thanks

 

[Sergius]

Hello! As an option, create a rule with such a formula

=$E2<>""

And remove the fill.

 

[Millevz]

Hello! As an option, create a rule with such a formula

=$E2<>""

And remove the fill.

Thanks but I cant get this to work

 

[Fluff]

Select B2:E4 & use this formula

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

 

[FletcherJ]

Thanks but I cant get this to work

The above formula only checks column E. So if E is not blank, then the rule applies. So look at your row and identify what columns are required to make the conditional formatting show or go away. So if those are E, H, and J must be filled in, then you could use the following to show the conditional formatting when those are missing (assuming your data starts in row 4: =or($E4="", $H4="",$J4="")
Note the $ signs to keep the columns constant while the rows can change.

 

[Millevz]

Select B2:E4 & use this formula

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

Thanks. This worked

 

[Fluff]

Glad we could help & thanks for the feedback.