Highlight a cell greater than the one above [Solved/Closed]

Ryan - Apr 27, 2010 at 08:00 AM - Latest reply:  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!!

See more 

2 replies

rizvisa1 4481 Posts Thursday January 28, 2010Registration dateContributorStatus January 6, 2016 Last seen - Apr 27, 2010 at 04:24 PM
0
Thank you
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
0
Thank you
That seems to have worked great! Thank you so much for your help!!