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

<tbody>
[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]FALSE[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]10-Mar[/TD]
[TD="align: right"]FALSE[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]9-Mar[/TD]
[TD="align: right"]TRUE[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]10-Mar[/TD]
[TD="align: right"]FALSE[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]11-Mar[/TD]
[TD="align: right"]FALSE[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]7-Mar[/TD]
[TD="align: right"]TRUE[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]13-Mar[/TD]
[TD="align: right"]FALSE[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]8-Mar[/TD]
[TD="align: right"]TRUE[/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]15-Mar[/TD]
[TD="align: right"]FALSE[/TD]

[TD="align: center"]11[/TD]
[TD="align: right"]7-Mar[/TD]
[TD="align: right"]TRUE[/TD]

</tbody>

Sheet8​