I want to use conditional formatting for cells that contain the value of a named range. "Year_Current" is the named range I am referencing and the cell it references is the current year, 2022.
I am using this formula =$G3=INDIRECT("Year_Current") in the conditional formatting which works fine for cells with 2022. I also want to use conditional formatting to highlight cells with years 2023 and 2024. I tried these but they did not work
=$G3=INDIRECT("Year_Current+1")
=$G3=INDIRECT("Year_Current"+1)
Any ideas?
I am using this formula =$G3=INDIRECT("Year_Current") in the conditional formatting which works fine for cells with 2022. I also want to use conditional formatting to highlight cells with years 2023 and 2024. I tried these but they did not work
=$G3=INDIRECT("Year_Current+1")
=$G3=INDIRECT("Year_Current"+1)
Any ideas?