Conditional Formatting

[Tahas]

Hi Friends,
I am trying to apply conditional formatting as follows:
Row 11 to 15

Code (column C)	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday
62

Row 19:

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

My conditional formatting =AND($C11=62,E11<>""). It highlights only to the first row. Am I doing something wrong?

 

[GWteB]

It should work:

Book1
	C	D	E	F	G	H	I
11	62		xxxx			dddd	aa
12	62			aa
13
14
15
16
17
18
19			Sunday	Mon	Tue	Wed	Thu
20			Sunday	Mon	Tue	Wed	Thu
Sheet23

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E19:I20	Expression	=AND($C11=62,E11<>"")	text	NO

 

[Tahas]

It should work:

Book1
	C	D	E	F	G	H	I
11	62		xxxx			dddd	aa
12	62			aa
13
14
15
16
17
18
19			Sunday	Mon	Tue	Wed	Thu
20			Sunday	Mon	Tue	Wed	Thu
Sheet23

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E19:I20	Expression	=AND($C11=62,E11<>"")	text	NO

Thanks so much!