Conditional Formatting: highlight numbers higher then previous values

[PatrickL]

Hello All,

I have a question about using the conditional formatting function to highlight all the numbers in a series that are the highest. I am creating a list of area sales for different franchise locations, and I want to highlight the months they did better than their previous best. In other words, if the numbers were $12, $15, $13, $17, and $16, I would want the 15 and 17 highlighted. Is that possible?

Thank you in advance,

Patrick

[ChemistB]

Not sure what Conditional formatting commands are available in Excel 2008 but try this. Let's say your data is in column A, from A2:A100. Select from A3:A100 and select conditional formatting by formula

Please Login or Register  to view this content.

and, of course, set your formatting colors/options. Does that work for you?

[PatrickL]

Thanks for the suggestion but unfortunately it didnt work. Any other ideas?

Thanks.

[ChemistB]

Maybe an example workbook would help. Here's an attached example in practice and it works like I believe you are requesting.

[PatrickL]

That worked! Thank you very much. This thread can be posted as solved. Thanks again.