Formula for conditional formatting?

[erniepoe]

Hi All,

I have a column that shows percentages. The percentages will start at a high number, then slowly dwindle, and then at some point, the percentage will start to go back up.

Is there any way to write a conditional format that will highlight the first percentage that increased from the value of the cell above it?

Essentially I am trying to find the inflection point in my data set. Thanks so much for any help!

 

[etaf]

under conditional formatting
select the range say
H2:H100
then use a formula
=H2>H1