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..
conditional formatting is purely a visual (formatting) tool.
If you want a value next to each cell (and not manually applied) you can use the same formula in a cell offset from A1 and then copy it into a range = to the size/shape of the range you want to check.
With Excel 365 (or 2021 I believe) you could also use dynamic array to output the range. For example
=(MOD(A1:D200,1)<=0.06)*(MOD(A1:D200,1)>0)
will 'SPILL" a table with 4 columns and 200 rows that correspond to the results from the range A1:D200
If you want a value next to each cell (and not manually applied) you can use the same formula in a cell offset from A1 and then copy it into a range = to the size/shape of the range you want to check.
With Excel 365 (or 2021 I believe) you could also use dynamic array to output the range. For example
=(MOD(A1:D200,1)<=0.06)*(MOD(A1:D200,1)>0)
will 'SPILL" a table with 4 columns and 200 rows that correspond to the results from the range A1:D200
Thank you so much! Have a great weekend