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?????