Conditional Formatting with Named Range

[gberg]

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?

 

[Rijnsent]

Try this:
=$G3=(INDIRECT("Year_Current")+1)

 

[FormR]

I don't think you need the INDIRECT() function.

=$G3=Year_Current

Should work just as well.

And to format the next year, simply:

=$G3=Year_Current+1

 

[gberg]

Well don't I feel silly. I was trying to make things more difficult, that works perfectly. Thanks for your help!