Conditioning Format if Criterias are met and to fill across columns of Dates based on start and end dates

[lewjan]

Hi,
Thank you in advance for your help and time.

Been trying for a while and can't seem to get the conditional formatting to work; grateful if you can assist.

Under the store column Whole = green and retail = red
If the criteria listed under the "store" column is met, I wanted the months column to be highlighted based on the start and end date.

Fruit	store	start date	end date	Sep-21	Oct-21	Nov-21	Dec-21	Jan-22	Feb-22
Apple	whole	10/1/2021	11/2/2021	green	green	green
orange	retail	12/15/2021	1/15/2022				red	red

Help!

Thanks much,
Jan

 

[JGordon11]

With the headers being the beginning of each month:

Book4
	A	B	C	D	E	F	G	H	I	J
1	Fruit	store	start date	end date	Sep 2021	Oct 2021	Nov 2021	Dec 2021	Jan 2022	Feb 2022
2	Apple	whole	10/1/2021	11/2/2021		green	green
3	orange	retail	12/15/2021	1/15/2022				red	red
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:J3	Expression	=(EOMONTH(E$1,0)>=$C2)*($B2="retail")*(E$1<=$D2)	text	YES
E2:J3	Expression	=(EOMONTH(E$1,0)>=$C2)*($B2="whole")*(E$1<=$D2)	text	NO

 

[lewjan]

Thanks @J

With the headers being the beginning of each month:

Book4
	A	B	C	D	E	F	G	H	I	J
1	Fruit	store	start date	end date	Sep 2021	Oct 2021	Nov 2021	Dec 2021	Jan 2022	Feb 2022
2	Apple	whole	10/1/2021	11/2/2021		green	green
3	orange	retail	12/15/2021	1/15/2022				red	red
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:J3	Expression	=(EOMONTH(E$1,0)>=$C2)*($B2="retail")*(E$1<=$D2)	text	YES
E2:J3	Expression	=(EOMONTH(E$1,0)>=$C2)*($B2="whole")*(E$1<=$D2)	text	NO

Thanks Much JGordon11! When I entered the expression, I also wanted it to highlight months between start and end dates. When I have dates from oct to dec 2021, it only highlighted Oct and Dec.
How can I highlight the months between the start and end dates? Sorry i wasn't clear in my ask. Thanks again!