Highlight integers only in Excel
This tutorial shows how to Highlight integers only in Excel using the example below; Formula =MOD(A1,1)=0 Explanation To highlight numbers that are integers, you can use a simple formula based on the MOD function. In the example shown, conditional formatting has been applied to the range B4:G11 using this formula: =MOD(B4,1)=0 Note: it’s important that CF …