Home

How to highlight cells in the same color as adjacent cells

%3CLINGO-SUB%20id%3D%22lingo-sub-699816%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-699816%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-699816%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-701415%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-701415%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F362229%22%20target%3D%22_blank%22%3E%40tdunkle%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfraid%20that's%20only%20with%20VBA%20programming.%20Formulas%20works%20with%20cells%20values%2C%20not%20with%20their%20properties%20as%20color.%3C%2FP%3E%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

@tdunkle 

 

Afraid that's only with VBA programming. Formulas works with cells values, not with their properties as color.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies