Forum Discussion

carleibowitz's avatar
carleibowitz
Copper Contributor
Mar 04, 2022

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

excel

8 Replies

  • mtarler's avatar
    mtarler
    Silver Contributor
    Mar 04, 2022
    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.

Resources