Conditional Format within a range of months based on start/end date

[lewjan]

Hi,
Thanks in advance for your time and help.

Based on the start and end dates, i wanted it to highlight the months & year these dates are within

Name	start date	end date	30-Nov-2021	30-Dec 2021	30-Jan 2022	28-Feb 2022
fork	1-Nov-2021	5-Jan-2022	fill in green	fill in green	fill in green
knife	23-Dec-2021	15-Feb-2022		fill in green	fill in green	fill in green

thank you so very much for your help!

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B	C	D	E	F	G
1	Name	start date	end date	30-Nov-21	30-Dec-21	30-Jan-22	28-Feb-22
2	fork	01-Nov-21	05-Jan-22
3	knife	23-Dec-21	15-Feb-22
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:G3	Expression	=AND($B2<=D$1,$C2>EOMONTH(D$1,-1))	text	NO

 

[Jeffrey Mahoney]

This CF formula assumes that you wanted the date at the top of the column to be within the dates in column B and column C inclusively.

=AND(D$1>$B2-1,D$1<$C2+1)