Change colour of block cells if other cells are full?

[Geek Girl 007]

I want Cells A4 through to F6 to go another colour if cells C4 though to F6 have text.....

I used this formula, =COUNTA($C4:$F6)=12 but as you can see it only highlighted the top row???
I have no idea what I am doing wrong???

Sorry I can only load images not mini sheet from my work PC.

 

[etaf]

lock the rows as well

try countA($C$4:$F$6)=12
and apply to A4:F6

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A4:F6 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=countA($C$4:$F$6)=12

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

i'll see if i have time to mock up an example

Utility-1.xlsx
	A	B	C	D	E	F
1
2
3			1
4			1	1	1	1
5			1	1	1	1
6			1	1	1	1
7
8
9
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A4:F6	Expression	=COUNTA($C$4:$F$6)=12	text	NO

 

[Sam_D_Ben]

Also , Please check

 

[Geek Girl 007]

lock the rows as well

try countA($C$4:$F$6)=12
and apply to A4:F6

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A4:F6 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=countA($C$4:$F$6)=12

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

i'll see if i have time to mock up an example

Utility-1.xlsx
	A	B	C	D	E	F
1
2
3			1
4			1	1	1	1
5			1	1	1	1
6			1	1	1	1
7
8
9
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A4:F6	Expression	=COUNTA($C$4:$F$6)=12	text	NO

Perfect, Thank you.

I was so close

 

[Geek Girl 007]

lock the rows as well

try countA($C$4:$F$6)=12
and apply to A4:F6

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A4:F6 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=countA($C$4:$F$6)=12

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

i'll see if i have time to mock up an example

Utility-1.xlsx
	A	B	C	D	E	F
1
2
3			1
4			1	1	1	1
5			1	1	1	1
6			1	1	1	1
7
8
9
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A4:F6	Expression	=COUNTA($C$4:$F$6)=12	text	NO

Would I be able to copy this to the next day??? I ask because of the $

 

[etaf]

no, its fixed - so a copy will keep the same rows

are those days in merged cells - that makes it all the more difficult

having a think on how to do for every row , based on groups of 4 rows

 

[Geek Girl 007]

no, its fixed - so a copy will keep the same rows

are those days in merged cells - that makes it all the more difficult

having a think on how to do for every row , based on groups of 4 rows

I posted it as a new question, I wasn't sure I was allowed to ask here again.
Thank you so much, I will take all and any help with this