Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 128
- Office Version
- 365
- Platform
- Windows
Hi,
I am inputting conditional formatting on a few cells in excel which are used for a check.
The check should return 0 if all is ok.
So the check is returning 0 for all the cells but the conditional formatting is still highlighting some of the cells as being not equal to 0.
I have even entered 0.00 in the conditional formatting formula.
From looking at some of the check cells that are "incorrectly" highlighting, they are not equal to zero which is clearly why they are being highlighted.
For example, a check cell may be 0.00000000186 and that is highlighting & I dont want it to because to two decimal places it is equal to zero.
How do I go around the above and set the formatting to highlight cells not equals to 0.00?
Thanks
I am inputting conditional formatting on a few cells in excel which are used for a check.
The check should return 0 if all is ok.
So the check is returning 0 for all the cells but the conditional formatting is still highlighting some of the cells as being not equal to 0.
I have even entered 0.00 in the conditional formatting formula.
From looking at some of the check cells that are "incorrectly" highlighting, they are not equal to zero which is clearly why they are being highlighted.
For example, a check cell may be 0.00000000186 and that is highlighting & I dont want it to because to two decimal places it is equal to zero.
How do I go around the above and set the formatting to highlight cells not equals to 0.00?
Thanks