varunwalla
New Member
- Joined
- Aug 13, 2020
- Messages
- 32
- Office Version
- 365
- 2019
- Platform
- Windows
- Mobile
- Web
Hi,
How can i highlight the cell on b4 based on the value i.e if it is positive the background of the cell should be in green color if it is in negative the background of the cell should be red
How can i highlight the cell on b4 based on the value i.e if it is positive the background of the cell should be in green color if it is in negative the background of the cell should be red
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Enter Value First Value | 300 | ||
2 | Enter Value Second Value | 200 | ||
3 | ||||
4 | Total | 100 | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B4 | B4 | =B1-B2 |