user2623359
Reputation: 33
Excel-Conditional Formatting- Highlight the difference that is greater than
I am trying to figure out the proper way to enter the formula.
I am looking at highlighting the difference that is greater than 20000000
=$H-$G>20000000?
any suggestions
Upvotes: 0
Views: 90
Answers (1)
BruceWayne
Reputation: 23283
AFAIK you can't really do it over a range like that. I believe you want this as your formula:
=$H2-$G2>20000000
and an applied to range of say
=$H$2:$G$1000
to do this for all cells from row 2 to 1000.
Upvotes: 1
Related Questions
- excel conditional formatting based on greater/less than in adjacent cell/column
- Highlight cell if value is different from the preceding cell
- How to highlight cells in excel based on the cell above it?
- Highlight a cell if the value is greater than the value of the cell from the preceding column
- 'Column compare' conditional formatting
- Excel conditional formatting: color based on comparison of values in a row
- Excel Conditional Formatting: Highlight cells if not equal
- Excel conditional formatting with multiple cell comparison
- How can Excel do conditional formatting based on a comparison with the above cell?
- Excel 2007 - Conditional Formatting - Comparing two cells in the same column?