Highlight a cell greater than the one above
Solved/Closed
Related:
- Highlight cells if greater than another column
- Folder highlight - Download - Customization
- If i can't see someone's highlights on instagram - Instagram Forum
- How to delete column in word - Guide
- Vba select column by name ✓ - Excel Forum
- Based on the cell values in cells b77 - Excel Forum
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
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
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