Prev: EXCEL (IF)
Next: Hyperlink to folder on Save
From: Brad on 12 May 2010 08:16
Both Jacob and Ms-Exl-Learner gave you a good start

Rather than using Z1>36 - 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?
First  |  Prev  | 
Pages: 1 2
Prev: EXCEL (IF)
Next: Hyperlink to folder on Save