Highlight a cell greater than the one above
Solved/Closed
Related:
- Highlight cells if greater than another column
- Folder highlight - Download - Customization
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- How would you change all cells containing the word pass to green - 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