Conditional Formatting - Not Fully Working

Sundance_Kid

Board Regular
Joined
Sep 2, 2017
Messages
128
Office Version
  1. 365
Platform
  1. 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
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
Which cells are you using this on?
 
Upvote 0
Which cells are you using this on?
Cells in an excel workbook. Basically I am looking up a pivot table to return values.
Then I total up the values returned and the check is taking away the total from thr values returned from the total of the actual pivot table itself.
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,048
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top