# Conditional format formula

#### srizki

##### Well-known Member
I have some percentages adding-up to hundred, I want a formula to use in conditional format that when these percentages do not adds up to 100% the cell should highlighted, so far it is easy in some of those columns there are only zeros, that adds up to as you guess correctly zero, BUT those are not really zeros, they could be 0.00001 or something like that, so if I use the 100% formula it highlights the zeros too. For 100% I used the formula ==B110<>100% , or Cell value is not equal to 1 both work perfectly ( unless there is another one more sophisticated, I am sure you can make many).
My question is how can I put both conditions in conditional formula, remember the zeros may not me zero, so we can not say if value is not equal to zero etc.
Thanks

### Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
srizki said:
I have some percentages adding-up to hundred, I want a formula to use in conditional format that when these percentages do not adds up to 100% the cell should highlighted, so far it is easy in some of those columns there are only zeros, that adds up to as you guess correctly zero, BUT those are not really zeros, they could be 0.00001 or something like that, so if I use the 100% formula it highlights the zeros too. For 100% I used the formula ==B110<>100% , or Cell value is not equal to 1 both work perfectly ( unless there is another one more sophisticated, I am sure you can make many).
My question is how can I put both conditions in conditional formula, remember the zeros may not me zero, so we can not say if value is not equal to zero etc.
Thanks

Wouldn't

=(\$B110 >= 0)*(\$B110 < 1)

do what you want?

Replies
2
Views
79
Replies
3
Views
377
Replies
3
Views
386
Replies
3
Views
257
Replies
42
Views
847

1,207,173
Messages
6,076,923
Members
446,242
Latest member
JECYN

### 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.

### Which adblocker are you using?

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

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