Conditional formatting if decimal number
Mumofpanda
Posted messages
2
Status
Member
-
Mumofpanda Posted messages 2 Status Member -
Mumofpanda Posted messages 2 Status Member -
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
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
-
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
