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


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



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