Share via

Conditional Formatting is not a whole number?

Anonymous
2019-10-09T18:23:19+00:00

Is there a way to highlight the cell if the results of an equation results in value not equal to a whole number?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2019-10-09T18:30:14+00:00

    If it is what you want?

    =AND(A1<>"",A1<>INT(A1))

    17 people found this answer helpful.
    0 comments
Answer accepted by question author
  1. Charles Kenyon 159.4K Reputation points Volunteer Moderator
    2019-10-09T18:39:47+00:00

    Here is a possibility with A2 as the subject.

    3 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. DaveM121 815.3K Reputation points Independent Advisor
    2019-10-09T19:27:24+00:00

    Hi Stephen

    Sure, you can do that, the simplest conditional formatting formula is this:

    =MOD(A1,1)>0

    (you may need to adjust the A1 cell reference)

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2019-10-09T19:49:24+00:00

    Thank you for the suggestions.  I used both of your formulas.  One to indicate an acceptable value and the other to indicate an unacceptable value

    Thank you,

    Stephen

    0 comments
  3. Anonymous
    2019-10-09T19:53:53+00:00

    Formulas used

    1 person found this answer helpful.
    0 comments