Conditional formatting cells based on current year

[Manexcel]

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.

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.

 

[Joe4]

Do this:

1. Select the range C3:J13
2. Go to Conditional Formatting and click "New Rule"
3. Select the "Use a formula to determine which cells to format" option
4. Enter the following formula:

=AND(YEAR(TODAY())=C$3,C3<>"")

5. Select your desired formatting option
6. Click "OK"

This will format all the cells in the column with the current year that are not blank.

 

[Manexcel]

Thank you so much for the quick response. Very much appreciated. My problem is resolved.

 

[Joe4]

You are welcome.
Glad I was able to help!