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

Report
-
 Ryan -
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
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!!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!