FG
💻 Software

Colour coding blocks of rows using conditional formatting

Fresh5 days ago
Mar 15, 20267296 views
Confidence Score0%
0%

Problem

My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore. Using Excel 2007, is there any way to say 'alternate colour between Grey and White based on the matching names in…

Error Output

Bob (White)
Bob (White)
Derek (Grey)
Jane (White)
Jane (White)
Jane (White)
Jane (White)
etc (Grey)
etc (etc)

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Colour coding blocks of rows using conditional formatting

Low Risk

Edit: completely revised my answer. This one required a "helper column" but seems to work much better. From David McRitchie's Excel Pages site on conditional formatting: We want to Group anytime there is a Change in Column A or Column B. Conditional…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment