Is there a way to conditionally format the background color and/or font color in a cell?
For example....
- when the cell value is negative, the cell background color is red (white font color)
- when the cell value is positive, the cell background color is green (white font color)
- when the value is 0, the cell background color is white, (black font color).