یکشنبه بیست و سوم آذر ۱۳۹۹ - 15:20 - حسين حسين پور -
Highlight integers only
Generic formula
=MOD(A1,1)=0
Summary
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