Conditional formatting

[wstubbert]

I am looking to highlight an entire row red if delivery has not been confirm, need it to update on a daily basis

[Pepe Le Mokko]

And how does one know the delivery was not confirmed?

[tridom]

Select the row of cells to highlight.

Open Conditional Formatting on the HOME Tab

Select New Rule

Select Use a Formula to determine which cells to format

Under the Edit the Rule Description, enter the formula you want to base the highlight on (such as =$A$1<>"") The $A$! in my example should be the cell where your delivery date is.

Click Format and set the fill color.

Click OK twice to get out.