hotdogs1999
Board Regular
- Joined
- Dec 11, 2018
- Messages
- 57
Hello,
See below table for referencing. I am trying to apply colour scale conditional formatting (3-colour scale) to column B, dependent on corresponding column A values
Minimum - A is greater than or equal to B (e.g. B4 and B2 would be red)
Midpoint - A is less than B, but no more than 500 less (e.g. B3 would be yellow)
Maximum - A is less than B by more than 500 (e.g. B1 would be green)
How do i do this?
See below table for referencing. I am trying to apply colour scale conditional formatting (3-colour scale) to column B, dependent on corresponding column A values
Minimum - A is greater than or equal to B (e.g. B4 and B2 would be red)
Midpoint - A is less than B, but no more than 500 less (e.g. B3 would be yellow)
Maximum - A is less than B by more than 500 (e.g. B1 would be green)
How do i do this?
A | B | |
1 | 10000 | 20000 |
2 | 15000 | 15000 |
3 | 34750 | 35000 |
4 | 5500 | 5000 |