Connect with experts and redefine what’s possible at work – join us at the Microsoft 365 Community Conference May 6-8. Learn more >

Forum Discussion

Copper Contributor

Sep 16, 2022

Formatting 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?

Formulas and Functions

dscheikey
Bronze Contributor
Sep 16, 2022
RayB999
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
- RayB999
  Copper Contributor
  Sep 22, 2022
  dscheikey Many thank for the help. All working now.

Share

Resources