bruntonomo
Board Regular
- Joined
- Jul 29, 2018
- Messages
- 67
- Office Version
- 365
- 2016
- Platform
- Windows
***THIS HAS BEEN SOLVED - MY APOLOGIES***
I'm looking to format a cell based on its value versus the value of another cell. I know how to format cells based on comparison of cell values, but my problem is I'm not sure what the formula would be in my instance.
My scenario is that I want to format a cell in green if it's within .5 of the cell to the right. If the left cell's value is greater than the right cell, then it would also be green. If the value is more than .5 below the cell to the right, it should be formatted red.
3.5 / 4 = 3.5 (green)
5 / 4 = 5 (green)
3.4 / 4 = 3.4 (red)
The kicker is I need the formula to be flexible in that it references the right cell and can calculate what .5 less than the value of that cell is, and make the correct formatting. Can someone help with a formula and give directions for what needs to be done with conditional formatting?
I'm looking to format a cell based on its value versus the value of another cell. I know how to format cells based on comparison of cell values, but my problem is I'm not sure what the formula would be in my instance.
My scenario is that I want to format a cell in green if it's within .5 of the cell to the right. If the left cell's value is greater than the right cell, then it would also be green. If the value is more than .5 below the cell to the right, it should be formatted red.
3.5 / 4 = 3.5 (green)
5 / 4 = 5 (green)
3.4 / 4 = 3.4 (red)
The kicker is I need the formula to be flexible in that it references the right cell and can calculate what .5 less than the value of that cell is, and make the correct formatting. Can someone help with a formula and give directions for what needs to be done with conditional formatting?
Last edited:
