Date highlight

New Contributor

Hi, if I have a training matrix in Excel and I need to know when a forklift licence is due for renewal for example how can I get Excel to make cell background red so I am alerted to it say one month before it expires 

2 Replies


Use conditional formatting to highlight information

Conditional formatting can help make patterns and trends in your data more apparent. To use it, you create rules that determine the format of cells based on their values


additional Information:

How To Conditional Formatting Based On Date In Excel?

How To Identify Or Highlight Expired Or Upcoming Dates In Excel?

none Microsoft sites

thanks I'll give it a go @Rhonda_1957