In H4, CF/ Formula Is (not Cell Value is)
=MAX(H6:H505)0.5

For your second question, yes in principle, but to define your H4 CF formula
we'd need to know what your CF conditions are in H6:H505
--
David Biddulph

"Raz" wrote in message
...
I have about 500 numbers in column H (from H6 to H505) and a title of the
column on H4, I would like to have a conditional formatting on H4 ff any
of
the numbers in H6 to H505 are greater than 0.5

Or if any of my conditioinal formatting in H6 to H505 are true, then I
want
H4 to get highlighted.

Is any of these possible?????