formula for noting historical high

[mania112]

I work for a finance company, and 1 of my jobs is to monitor fund performance.

every month our clients fund value is inputted on a sheet.

is there a way to

a) mark the highest value - being the Historical High for that clients funds.
and then
b) mark a new value if it falls 5% or more below the historical high?

I think the best way it would work for me is to change the colour of a value if it is either the historical high, or if it falls 5% below.

I hope i'm explaining myself ok - pointers in the right direction greatly received.

[Palmetto]

Use Conditional Format for the cells.

First Condtion, formula: =A1=MAX($A$1:A10)
Second Condition, formula: =A1=MAX($A$1:A10)-(MAX($A$1:A10)*0.05)

[newmisslesylo]

palmetto has the right idea but the second condition should be:

=A1<=MAX($A$1:A10)-(MAX($A$1:A10)*0.05)

or

=A1<=(MAX($A$1:A10)*(1-0.05))

[mania112]

thats great thanks.

is there a way to apply this one row and drag it down (like a regular formula) to save my inputting this on every line?

[mania112]

ttt.

i need to know if you enter a conditional formatting as a formula along a row, if there's a quick way to apply that along all the rows without inputting the CF on each individual line

thanks