Share via

Conditional Formatting

Anonymous
2024-11-22T05:21:41+00:00

Dearest Wizards,

COL G11:G111 has many different values.

How do I write the CLASSIC formula that's needed to format any ROW (12-110) from Col C to Col X when the the value in COL G ABOVE the row is different than the value in COL G BELOW the row.

TIA for your help with this,

Sam

Microsoft 365 and Office | Excel | Other | MacOS

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-11-22T07:08:01+00:00

    Hi SamBeardsley,

    Thanks for your post in Microsoft Community.

    Try this formula to create a conditional format:

    =AND($G12<>$G11, $G12<>$G13)

    The logic of the formula is to determine whether the value in the cell of column G is equal to its adjacent cells above and below. If it is not equal, then highlight the entire row. 

    Please note that the range for the conditional formatting is C12:X110, so the conditional formatting will only apply within this range, not the entire row A:Z.

    I hope the formula works for you, and I look forward to your reply!

    Best Regards,

    Thomas C - MSFT | Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments