I have a row of columns (c3: j3) with year dates 2023 to 2030. Formatted as yyyy.
Under each year column, say 2023 (c3), there are several cells which I would only like highlighted in, say yellow. Including the year, say 2023
As each year progresses to 2024 (d3) I would like only column d3 to be highlighted in yellow etc.
I don't believe there is a formula within conditional formatting for the current year so am looking for a formula that will overcome.
Thank you for your time and consideration.
Under each year column, say 2023 (c3), there are several cells which I would only like highlighted in, say yellow. Including the year, say 2023
As each year progresses to 2024 (d3) I would like only column d3 to be highlighted in yellow etc.
Task | c3 | d3 | e3 | j3 |
2023 | 2024 | 2025 | 2030 | |
Task1 | a | b | c | |
Task 2 | a | b | c | |
Task10 | a | b | c |
I don't believe there is a formula within conditional formatting for the current year so am looking for a formula that will overcome.
Thank you for your time and consideration.