Home

How to highlight cells in the same color as adjacent cells

%3CLINGO-SUB%20id%3D%22lingo-sub-699814%22%20slang%3D%22en-US%22%3EHow%20to%20highlight%20cells%20in%20the%20same%20color%20as%20adjacent%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-699814%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20should%20be%20EASY%2C%20but%20darned%20if%20I%20can%20find%20it%20by%20googling%20or%20by%20searching%20Excel's%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20automatically%20highlight%20each%20of%20the%20cells%20in%20a%20column%20with%20the%20same%20color%20as%20the%20cells%20to%20the%20left%20or%20right%20of%20them%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20is%2C%20if%20a%20cell%20in%20column%20B%20is%20highlighted%20green%2C%20how%20do%20I%20make%20the%20adjacent%20cell%20in%20column%20C%20also%20highlight%20in%20green%3F%20And%20if%20B%20is%20pink%2C%20make%20C%20also%20pink%3F%20And%20so%20on.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20don't%20want%20the%20formula%20for%20C%20to%20do%20ANYTHING%20but%20match%20the%20highlighting%20in%20B.%20The%20formula%20should%20not%20involve%20the%20actual%20values%20in%20either%20column%20--%20it's%20all%20about%20the%20highlight%20color%20and%20ONLY%20the%20highlight%20color.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-699814%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-699972%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20highlight%20cells%20in%20the%20same%20color%20as%20adjacent%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-699972%22%20slang%3D%22en-US%22%3EIn%20defining%20the%20conditional%20formatting%20formula%2C%20select%20columns%20B%20and%20C%2C%20then%20in%20the%20formula%2C%20use%20Absolute%20reference%20for%20column%20B%20and%20relative%20for%20the%20row%20number%2C%20like%20this%3A%3CBR%20%2F%3E%24B2%3C%2FLINGO-BODY%3E
tdunkle
New Contributor

This should be EASY, but darned if I can find it by googling or by searching Excel's help.

 

How do I automatically highlight each of the cells in a column with the same color as the cells to the left or right of them?

That is, if a cell in column B is highlighted green, how do I make the adjacent cell in column C also highlight in green? And if B is pink, make C also pink? And so on.

I don't want the formula for C to do ANYTHING but match the highlighting in B. The formula should not involve the actual values in either column -- it's all about the highlight color and ONLY the highlight color.

1 Reply
In defining the conditional formatting formula, select columns B and C, then in the formula, use Absolute reference for column B and relative for the row number, like this:
$B2
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies