Conditional formatting if decimal number

Hello,

I want to apply conditional formatting in a table in case the result in my cell is a decimal number.

Example: in my cell E5, the formula applied is C5/5. If the result is a decimal number, I want to highlight it by changing the font color.

Thank you

Configuration: Windows / Chrome 70.0.3538.102

1 answer

  • Votes
  • Date
  • Descending date
  1. Moderator
    Hello,

    You can use a new conditional formatting rule of the "formula" style and within it, compare the value of the cell with that of its integer
    for example:
    =INT(E5)=E5 

    there.. if the condition is true, it means it is not a decimal number.
    of course, you can also do it with "not equal" <> so that it returns true when it is a decimal number.

    --
    Best regards,
    Jordane
    1. Great! Thank you very much!