Highlight a cell greater than the one above

Solved/Closed
Ryan - Apr 27, 2010 at 08:00 AM
 Ryan - May 3, 2010 at 08:15 AM
Hello,

I am trying to use conditional formatting to highlight cells in a column (formatted as a table) that are greater than the number in the cell above it. I am trying to trend up/down data and dont want to insert more columns to make it easier.

For example, my table looks similar to this:

A B C D

1 10.5 4.5 28 15.5
2 26.5 2.5 16.5 32
3 18 3 11 21.5

My end result would highlight cells A2, B3, and D2 in green. Best case scenario, it would highlight the rest of the cells in red.

Any help would be greatly appreciated!!

Related:

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 27, 2010 at 04:24 PM
Select all rows except for row 1 under the the columns A-D

then go to conditional format and enter this formula
=A2>A1
then under conditional format, click format and choose color blue

again go to conditional format and enter this formula
=AND(A1>=A2,NOT(AND(ISBLANK(A1),ISBLANK(A2))))

and choose color red
That seems to have worked great! Thank you so much for your help!!