RayB999Copper ContributorSep 16, 2022Formatting Cells with Expiry Dates I have a column with expiry dates for products. How can I automatically make that cell red if the expiry date has passed?
dscheikeyBronze ContributorSep 16, 2022RayB999 You can easily do this with "Conditional Formatting". See also screenshot with example from Excel for the web, or in the enclosed file. cond_form.xlsx9 KB
RayB999Copper Contributor to dscheikeySep 22, 2022dscheikey Many thank for the help. All working now.
RayB999Copper Contributor to dscheikeySep 22, 2022dscheikey Many thank for the help. All working now.
