Values that display Excel 2013 cell data as integers in different colors

Case Tutorials

① start Excel2013, see the following table data, select the D1:d7 area, click the menu bar-conditional formatting-create a new rule.

② The New Rule dialog box, select the cell that you want to format by using a formula, and then enter the formula: = $D 1-int ($D 1) =0, click the Format button.

③ formatting cells here, I'll show you, not set so detailed, in yellow.

After the ④ is determined, the cell with the column data as an integer becomes yellow.

Formula meaning

Int (number): Rounds a number down to the nearest integer.

The INT function is used to extract the integer portion of the cell, and then the integer part is subtracted from the cell itself, and if the result is 0, the value of the cell is an integer, otherwise, it is not an integer.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join

Classification:

• Excel Tutorials