Both Jacob and Ms-Exl-Learner gave you a good start

Rather than using Z136 - use Max(Z:Z)36
--
Wag more, bark less


"Alicia-Paris" wrote:

If COLUMN Z is more than 36... then i want it to highlight the entire row.

I have 70 rows, all with different numbers in that are already all working,
however, if the number gets above 36 in the Z COLUMN, i want it to highligh
the ENTIRE row. How do I get it to do this please guys?