Condional Formatting within a list of dates

[John Smucker]

I have a list of dates from 01/01/2022 through 12/31/2022 This gives me 365 dates
I dragged it down another row to count the leap year, now for the year 2022 01/01/2023 appears and i want to conditionally format this list so that any dates from the next years would not show.
I tried this formula =YEAR(B368)<>YEAR(B3) and formatted the number to custom>;;; to take away the value and it took away all my dates..
Can someone explain why this isn't working

Cell B3 is the first date in the list

Cell B368 is the last date in the list

 

[JamesCanale]

It really depends on what exactly you have selected when you start the conditional formatting.

Here is the last few rows of it working (thanks - I learned about the ;;; thing). It works great.

MrExcelPlayground11.xlsx
	B
350	12/14/2022
351	12/15/2022
352	12/16/2022
353	12/17/2022
354	12/18/2022
355	12/19/2022
356	12/20/2022
357	12/21/2022
358	12/22/2022
359	12/23/2022
360	12/24/2022
361	12/25/2022
362	12/26/2022
363	12/27/2022
364	12/28/2022
365	12/29/2022
366	12/30/2022
367	12/31/2022
368
Sheet15

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:B368	Expression	=YEAR(B3)<>YEAR(B$3)	text	NO

 

[Fluff]

As you have 365, rather than dragging the dates why not use a spill formula that will never return dates from next year.

Fluff.xlsm
	A	B	C
1
2
3		01/01/2022	01/01/2020
4		02/01/2022	02/01/2020
5		03/01/2022	03/01/2020
6		04/01/2022	04/01/2020
7		05/01/2022	05/01/2020
8		06/01/2022	06/01/2020
9		07/01/2022	07/01/2020
10		08/01/2022	08/01/2020
11		09/01/2022	09/01/2020
12		10/01/2022	10/01/2020
363		27/12/2022	26/12/2020
364		28/12/2022	27/12/2020
365		29/12/2022	28/12/2020
366		30/12/2022	29/12/2020
367		31/12/2022	30/12/2020
368			31/12/2020
369
Data

Cell Formulas
Range	Formula
B4:B367,C4:C368	B4	=B3+SEQUENCE(DATE(YEAR(B3),12,31)-B3)
Dynamic array formulas.