Conditional Formatting and setting new rules

[leahschadeck5]

Hello, I am looking to Create a New Rule and I need to use a formula to determine the cells i want to format, but after hours of research, I have not been able find the correct formula.
I currently have a table Column Length A to K. Row Length 1 to 48. Row 1 is all headers.

When a date is entered into Column K I want that row to change color.
example being: if cell K12 has 1/21/22 entered in it. I would like A12:J12 to change color.
if K44 has a date entered, I would like A44:J44 to change color.

I used : formula =$K$2 [format] Applies to =$A$2:$J$2
and that seemed to work for 1 of the cells in Column K. I am hoping that I wouldnt have to list a new rule for every cell in Column K, and there has to be a formula that applied to the whole table base on Column K not being blank.

 

[jtakw]

Hi,

Start selecting your range in Column A where your data starts, in my sample below, A2, select entire range you want CF, in my sample, A2:J7
CF, using formula, enter formula as shown, in my sample =$K2 (change cell reference according to your First data Row, $K2, absolute referecing for Column Only, Not row), Format>Fill>OK

Book3.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10	Date?
2											1/30/2022
3
4											1/15/2022
5											1/16/2022
6
7											1/31/2022
Sheet975

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:J7	Expression	=$K2	text	NO

 

[leahschadeck5]

Hi,

Start selecting your range in Column A where your data starts, in my sample below, A2, select entire range you want CF, in my sample, A2:J7
CF, using formula, enter formula as shown, in my sample =$K2 (change cell reference according to your First data Row, $K2, absolute referecing for Column Only, Not row), Format>Fill>OK

Book3.xlsx
	A	B	C	D	E	F	G	H	I	J	K
1	Header 1	Header 2	Header 3	Header 4	Header 5	Header 6	Header 7	Header 8	Header 9	Header 10	Date?
2											1/30/2022
3
4											1/15/2022
5											1/16/2022
6
7											1/31/2022
Sheet975

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:J7	Expression	=$K2	text	NO

Sorry I am a bit new to this...
What should my formula be then?

 

[jtakw]

I currently have a table Column Length A to K. Row Length 1 to 48. Row 1 is all headers.

Sorry I am a bit new to this...
What should my formula be then?

Select A2:J49, CF, use formula, enter formula =$K2, Format, Fill, choose your fill, OK