Conditional formatting of a row if a cell is blank but only if text in another cell

[Bolter LAC]

Hello again,

Conditional formatting issue. Have a number of columns and if a cell is blank in the date completed column the row is highlighted. The conditional formatting is working fine but I cannot work out how to make it apply to new tasks I am adding. If I select a range (my worksheet) then the formatting applies to rows where I have not created a task (eg Task 3,4,5). The formula I am using is =$E2="" and the format is yellow infill.

Task No.	Date	Estate	Task Description	Date Completed	Staff Involved	Comments
1	25/11/2020	Location 1	General maintenance	30/11/2020	Staff member	Nil
2	27/11/2020	Location 2	Repairs to Stage 3		Staff member	Nil
3

Any help appreciated.

Bolter LAC

 

[6StringJazzer]

Update to:

=AND($B2>0,$E2="")

This will require a date for the row to be highlighted.

 

[Bolter LAC]

Champion 6StringJazzer. Thanks Mr Excel again.

 

[6StringJazzer]

Glad I was able to help!