Jun 09 2022 01:36 AM
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
Jun 09 2022 01:55 AM
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