I have a tracking spreadsheet, and I am looking to highlight cells in column H if the date in column E is more than 182 days in the past only if the cells in column H are blank.
Not sure if I'm explaining this well, so let me give an example based on today's date, 1/25/2022.
182 days before today is July 27, 2021. So, let's say that we have the following information in this table:
In the above example, I need cell H1 to highlight, but cell H2 should not be highlighted because it isn't blank.
Any help is much appreciated!
Bookmarks