Limiting conditional formatting to decimal places

[xxthegiantxx]

I have formulas set up in cells that calculate to multiple decimal places. I have used "Increase Decimal" and "Decrease Decimal" to show three decimal places. Beyond the three decimal places are irrelevant to what i am trying to do. I have used conditional formatting to change the fill color above or below a certain number. However, the conditional formatting is using all of the decimal points beyond the three. How do i set up conditional formatting to ignore any decimal beyond the three i set the viewer to.

 

[BarryL]

Maybe a rule something along the lines of

=LEFT(K1,SEARCH(".",K1)+3)>"0.001"

 

[63falcondude]

When you change the format of a number by using increase or decrease decimal, you are only changing how it is being displayed and not the actual number itself.

e.g. if you have the number 12.0346 in A1 and change the formatting to show 12.035, =A1=12.035 will return FALSE because A1 is actually 12.0346.

This is the same with Conditional Formatting so you will have to take that into account.

 

[xxthegiantxx]

Nominal	Actual	tolerance	Green-	Green+	Tolerance	Yellow-	Yellow+
10.000	10.023	0.015	9.985	10.015	0.0225	9.9775	10.0225

<tbody>
</tbody>

The formula didn't work or maybe i didn't apply it correctly so i will be more specific. Tolerance calculates via a formula i have written. It then gives you a range of measurements that tolerance would apply to. I have it set the viewer to show three decimal places because that is all i am concerned about (I realize this has no effect on the value of the number in the cell). The number in the actual field should change color based on the range it falls under i.e. green, yellow, or outside of those ranges is red. However, as you can see the formula calculates the tolerance of the yellow field to be 0.0225. I am only concerned about 3 decimal places so i would like the decimal to round up so that conditional formatting is correct. In other words, an actual measurement of 10.023 should change to yellow. It changes to red because 10.023 is technically larger than 10.0225.