Color count Conditional Formatting Via rows into total columns

[RADICAL_THOUGHT]

hello, I would like to count the yellow cells into the AL column via each row as it is a rota however, the cells I am trying to count in that column are already conditional formatted.

TIA

 

[6StringJazzer]

Yes, they are yellow, but they also all have "AL". You can use

=COUNTIF(C3:AG3,"AL")

copy down.

Also avoid the use of merged cells.

 

[RADICAL_THOUGHT]

Thankyou, is there a way to extend a cell without merging and it affecting the other rows then

 

[6StringJazzer]

What do you mean "extend a cell"? What is the result you want?

 

[RADICAL_THOUGHT]

the last message i got was try to avoid merging so wasnt sure if i could extend cells without extending the whole column sorry for late reply i didnt realsie i got a message

 

[6StringJazzer]

I asked what you meant by "extending" a cell and you just repeated "extend cells" again. I still don't know what you mean by "extend". Please show what result you want.