I have a cell that contains a date in the format 21-Feb-21. I would like it to shade it green if the year in the date is the current year.
I am going to have a second rule where if the year in the cell is before (less than) the current date than shade red.
I believe I can do it simply but bulky by inserting a cell with the TODAY function. Then add two more cells where I extract the year from my cell and TODAY. Then conditional format those in the appropriate cell. But I'm sure there is a less cumbersome way to do it.
I am going to have a second rule where if the year in the cell is before (less than) the current date than shade red.
I believe I can do it simply but bulky by inserting a cell with the TODAY function. Then add two more cells where I extract the year from my cell and TODAY. Then conditional format those in the appropriate cell. But I'm sure there is a less cumbersome way to do it.