CODEWITHSUNDEEP
exceldateexcel-formulaworksheet-functionconditional-formatting
Jade Hillier
Jade Hillier

Reputation: 11

Format Rules in Excel?

I'm setting up a spreadsheet which has a date received column and a date acknowledged column. I want the date acknowledged column to highlight red ten days after date received if the date acknowledged cell is blank, but once a date is entered in, it will returns to normal no color.

How might I achieve this?

Upvotes: 1

Views: 49

Answers (1)

pnuts
pnuts

Reputation: 59485

Assuming your date received column is A and acknowledged is ColumnB, please select Column A and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format, Format values where this formula is true:: 

 =AND(ISBLANK(B1),TODAY()>A1+10,A1<>"")

Format..., Fill, select red, OK, OK.

Upvotes: 2

Related Questions