Formatting Cells with Expiry Dates

[RayB999]

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

[#2]

@RayB999 

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

[#3]

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