Oops, apology

should read as
1. Select the cells you want to format, ( H4 )

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis





"francis" wrote:

try

1. Select the cells you want to format, ( H6:H505 )
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=COUNTIF($H$5:$H$13,"0.5")
5. Click the Format button
6. Click Format and choose a color
7. Click OK twice.
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"Raz" wrote:

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