How to make a conditional formt apply to all cells?

[Cerin1]

I’ve made a conditional format color a row green when a formula is true. However, it’s only applying to a specific range of rows, and I’m trying to make it apply to all rows.

My formula is:

AND($Q2>=90, $R2>=90, OR($S2>=90, $S2>=$O2), OR($T2>=75, $N2>=6, AND($P2>0, $T2>0, $T2>=$P2)))

and the cell range is:

E2:E1000,G2:H1000,A233:B251,P255:T257,U255,U259:U1108,A255:A256,A258:T1108,N2:P16,C232:N251,A252:N253,P254:U254,O226:P253,U257,B254:O257,A226:N231,Q226:U253,A204,C204:U204,A17:U203,A205:U225

I’ve tried change row numbers in the cell range to x2:x1000, but that causes Libreoffice to replace all the cell references in the formula to:

AND($Q#REF!>=90, $R#REF!>=90, OR($S#REF!>=90, $S#REF!>=$O#REF!), OR($T#REF!>=75, $N#REF!>=6, AND($P#REF!>0, $T#REF!>0, $T#REF!>=$P#REF!)))

Why does expanding the cell range to include all rows cause the formula to become corrupted?

[karolus]

apart how to handle umpty of Cellranges…

this part-expression is logical oversized

@Cerin1

AND($P2>0, $T2>0, $T2>=$P2)

if ‘P2>0’ and ‘T2>=P2’ we can assume that ‘T2>0’ and dont need to check it

[Wanderer]

@Cerin1

Why does expanding the cell range to include all rows cause the formula to become corrupted?

It seems the complete formula is re-evaluated based on the active cell and you may have been further down the table maybe x10.

So make sure you are in row 2 when you edit the condition, would be my first try.