Conditional Formating Dates

[Renae]

Hi there

I have a speadsheet where the current date will be entered when a product has been place on hold. the sales reps then has 2 days to complete this sale, after 2 days are up i want the date in the cell to be highlighted red. If no date is entered into the cell yet i would like it to remain blank.

can someone please help me do this.

Thanks in advance

 

[Weazel]

maybe something like

=AND($B2<>"",TODAY()-$B2>2)

as a conditional formatting rule


Excel 2012

	B	C
2		FALSE
3	10-Mar	FALSE
4	9-Mar	TRUE
5	10-Mar	FALSE
6	11-Mar	FALSE
7	7-Mar	TRUE
8	13-Mar	FALSE
9	8-Mar	TRUE
10	15-Mar	FALSE
11	7-Mar	TRUE

<tbody>
</tbody>

Sheet8​