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..
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)
- Thanks this worked real well. How do I now identity just those cells that I have highlighted?
put some sort integer in next column next to cell? or true false statement?
