Forum Discussion
Excel highlight for dates exception
I need help highlighting items older than: one year, 2 years and 3 years within an index I have created in excel. The index is a Chemical SDS identifier. These issue dates have to be updated and revised so being able to click a circle (dev tool) and auto highlighting these dates is super important. How do I do this within excel?
Hi Maria,
You may apply Conditional formatting https://support.office.com/en-ie/article/Use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f?ui=en-US&rs=en-IE&ad=IE using rule with DATEDIF https://support.office.com/en-us/article/DATEDIF-function-25dba1a4-2812-480b-84dd-8b32a451b35c and TODAY() functions
