Formatting Cells with Expiry Dates

New Contributor

I have a column with expiry dates for products. How can I automatically make that cell red if the expiry date has passed?

2 Replies

@RayB999 

You can easily do this with "Conditional Formatting". See also screenshot with example from Excel for the web, or in the enclosed file.

dscheikey_0-1663336016055.png

 

@dscheikey Many thank for the help. All working now.