Conditional Formatting complete rows in data table - inconsistent

Done it a thousand times successfully before but something's gone horribly wrong!

I'm trying to format the whole row based on a cell's value - simple isn't it?

The attached will be of more use than any attempt I may make at articulating the issue, however here's a summary:

If cell value is greater than another cell value, turn row red....
Cells in the range of =P27:T27 clearly meet this condition, however other areas of this row fail to meet the condition but are highlighted.

If cell value > 0 and less than another cell, then green row...
Row 32 works fine to column AN and then just quits applying the rule! Row 20 works to row R and then stops.

I thought it may be due to the row headers being text but then it wouldn't break halfway through the row.
I really hope I've done something idiotic and that there is some rational logic behind this.... If I needed this level of chaos in my life, I'd run a day care centre for preschool kids!

I'm looking at all the cells in each row - where a cell is encountered that meets the condition, then the whole row is highlighted.

I'm only concerned with the numeric cells from column F onwards for meeting the condition, however I have to apply to the whole table range in order to format the complete row.

Indeed.

I think I've sussed it now too - just applying all the logic again in a COUNTIF.

Where any single cell in a row exceeds a value, then I want the whole row highlighted - don't care about individual cells. So For the red condition, I've now got

 =COUNTIF($F2:$BR2,">"&$E2)

which seems to fulfil this criteria perfectly.

With this logic, I should be able to do all the rest of the formatting too I hope....

Indeed - it's looking in the range $F2:$BR2 and counting any cell in the range > $E2.

Where the count >0, each row in the applied to range ($A$2:$BR$59) will be highlighted.

Attached the now working example if this helps.

Indeed - it's looking in the range $F2:$BR2 and counting any cell in the range > $E2.

Where the count >0, each row in the applied to range ($A$2:$BR$59) will be highlighted.