Automatically change cell colour when cell date expires

[davash]

Hi.

Can anyone tell me how to add a formula that automatically changes the colour of a cell to red once the date within that cell expires please?

Thanks.

David

 

[GirishDhruva]

Hi.

date within that cell expires please?

Means less than today?????

 

[gallen]

Select the cells with the dates in

Home>Conditional Formatting>New Rule>Use a formula to determine which cells to format

Assuming A1 is the first cell in your selection:

In the 'Format values where this formula is true' box enter :

=A1<Today()
<today()[ code]

Changing A1 to the first cell of your selection.

Ensure to click the 'Format' button and select the format for when the value returns true</today()[>

 

[davash]

Thanks for your very quick reply.

I got as far as "ensure to click the format button and select the format for when the value returns true". I clicked on format and entered the cell range, but not sure where to go from there. Can you advise please?

Thanks

 

[Fluff]

What cells do you want this to work on?

 

[davash]

D2 to D800

 

[Fluff]

In that case select those cells > Conditional Formatting > New Rule > Use a formula >
=D2< Today()
Select the format you want > Ok

 

[davash]

Brilliant. THanks for your help. Have a great day.

 

[Fluff]

You're welcome & thanks for the feedback