Forum Discussion
identifying decimals under .06 in excel spreadsheet
Hello, I need to highlight all numbers in a spreadsheet that have a decimal less than .06 for example I want to highlight .06, 1.02, 12.03, but not 2.11 , 3.08 etc..
You can use Conditional formatting. Highlight entire area and then Home -> Conditional Formatting - New Rule - Custom Formula (on the formula line type): =MOD(A1,1)<=0.06 This assumes that the area includes cell A1. If not use the top left most cell in the selected area.
everything was highlighted
- wait, it did work.
- can I please ask one more thing. I need greater than .00 and less than .06. How do I edit the formula?
- =(MOD(A1,1)<=0.06)*(MOD(A1,1)>0)