Share via

format or formula for a cell to change color if it not equal to another cell.

Anonymous
2012-10-18T20:01:20+00:00

Hi, I need to create a format or formula for a cell to change color if it not equal to another cell.   Then I will need to copy that formula to the rest of the row.

For example:

Hours logged into D3 + E3 = F3  I need to know if the hours logged into G3 are equal to that in F3.  If it is NOT equal I need G3 to change color.

Thanks

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
    2012-10-18T20:14:17+00:00

    Hi,

    1. Go to cell F3
    2. Press Alt+O then release Alt and press D
    3. In Conditional Formating manager dialog box, click NEW RULE
    4. Select Use a formula to determine which cells to format (last rule type)
    5. Enter this formula in Format values where this formula is true text box

    =$F3<>$G3

    1. Click format, then in fill tab select your fill color you wish if F3 doesnt equal from G3

    7. OK

    8. OK

    1. OK
    2. Now copy F3, then paste downward.

    Hope it helps,

    Jaeson

    50+ people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-07-23T05:16:52+00:00

    My problem is similar so this is somewhat helpful. From what I see this would apply to a single row so how do I get it to apply apply to the whole worksheet?

    8 people found this answer helpful.
    0 comments
  2. Anonymous
    2012-10-18T20:20:40+00:00

    You can do this with Conditional Formatting. Select the cell(s) that are to be colored and choose Conditional Formatting from the Styles panel of the Home tab of the Ribbon. In the dropdown menu, choose "New Rule". There, select "Use a formula to determine which cells to format". In the "Format values where this formula is true:" box, enter =$F3<>$G3. Click on the Format button to choose your style. When the formula is TRUE, that formatting will be applied. If the formula is FALSE, no formatting is applied.

    7 people found this answer helpful.
    0 comments
  3. Anonymous
    2012-10-18T20:24:21+00:00

    Thank you so much!!

    0 comments