Change the colour of a cell

[sjcaddy]

I want to change the colour of cells based on whether the start and end dates match the month (column)

 

[jtakw]

Hi,

Are you perhaps saying All the Cells marked with an "X" should be colored?
If so, CF, using formula

Book3.xlsx
	E	F	G	H	I
2	x	x	x	x	x
3			x	x	x
Sheet974

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:I3	Expression	=E2="x"	text	NO

 

[sjcaddy]

Thank you, but I used the X just as an example, I will not have any content in the cell. So E2 should change colour as E1 falls between the start date Jan 22 (B2) and end date (C2)

 

[jtakw]

Thank you, but I used the X just as an example, I will not have any content in the cell. So E2 should change colour as E1 falls between the start date Jan 22 (B2) and end date (C2)

Then, do you want a formula that Will put an "x" in the relevant cells also ?
Or, are they Supposed to stay Blank ?

 

[sjcaddy]

I would like them to stay Blank, thank you

 

[sjcaddy]

Although, having a formula too would help me later when I will need it

 

[jtakw]

I would like them to stay Blank, thank you

Stay Blank, CF Only:

Book3.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1				Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23
2	Jan-22	May-23
3	Mar-22	Dec-22
Sheet974 (2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:U3	Expression	=AND(E$1>=$B2,E$1<=$C2)	text	NO

Although, having a formula too would help me later when I will need it

With formula to mark "x", And CF:

Book3.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1				Jan-22	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Apr-23	May-23
2	Jan-22	May-23		x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x	x
3	Mar-22	Dec-22				x	x	x	x	x	x	x	x	x	x
Sheet974

Cell Formulas
Range	Formula
E2:U3	E2	=IF(AND(E$1>=$B2,E$1<=$C2),"x","")

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E2:U3	Expression	=E2="x"	text	NO

 

[sjcaddy]

Very much appreciated! Thanks, I have it working

 

[jtakw]

You're welcome, thanks for the feedback.