Conditional Format - Highlight Cell Based on Date

[Kirrash]

I would like to use conditional formatting to highlight duplicate client ID in column B - but only for the current year (column C).

I know I'm missing something and overthinking the issue. The conditional format I have tried is:

=AND($B1:$B4,">="&DATE(2024,1,1),"<="&DATE(2024,12,31),$C1:$C4>1)

I have also tried the below formula using a blank worksheet (and I did not keep the columns identical).

=COUNTIFS($C$5:$C$10,$C5,$C$5:$C$10,"<>",$B$5:$B10,"<="&DATE(2024,1,1)>1)

Thank you.

 

[DanteAmor]

Will I have to continually update the "Applies to"

Just:

=$B$2:$B$1000