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!!

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
0
That seems to have worked great! Thank you so much for your help!!
0