SOLVED

Formula, Conditional Formatting, or Macro for banded coloring rows of cells?

%3CLINGO-SUB%20id%3D%22lingo-sub-2972551%22%20slang%3D%22en-US%22%3EFormula%2C%20Conditional%20Formatting%2C%20or%20Macro%20for%20banded%20coloring%20rows%20of%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2972551%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20set%20up%20some%20sort%20of%20automation%20to%20color%20rows%20to%20differentiate%20orders%20based%20on%20PO%23.%20I%20have%20included%20an%20example%20below.%20We%20are%20looking%20to%20easily%20visualize%20when%20one%20PO%23%20stops%20and%20another%20begins.%20As%20it%20stands%2C%20this%20is%20a%20manual%20process%20but%20I%20would%20love%20to%20automate%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20you%20can%20see%2C%20each%20PO%23%20is%20colored%20in%20to%20separate%20it%20from%20the%20previous%20PO%23's%20color%20by%20either%20being%20grey%20or%20white.%20I%20don't%20know%20how%20to%20set%20up%20a%20formula%20or%20anything%20to%20make%20excel%20color%20a%20row%20in%20this%20fashion.%20If%20anyone%20can%20help%20or%20offer%20a%20solution%20that%20would%20be%20incredibly%20helpful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22BromanGladiator_1-1637098989532.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F327391i7B4AAD98BE12CBA3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22BromanGladiator_1-1637098989532.png%22%20alt%3D%22BromanGladiator_1-1637098989532.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%20Looking%20forward%20to%20getting%20this%20automated!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2972551%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2972574%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%2C%20Conditional%20Formatting%2C%20or%20Macro%20for%20banded%20coloring%20rows%20of%20cells%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2972574%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1220755%22%20target%3D%22_blank%22%3E%40BromanGladiator%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%20I%20created%20a%20conditional%20formatting%20rule%20of%20type%20formula.%3C%2FP%3E%0A%3CP%3ETo%20inspect%20the%20rule%2C%20select%20A2%20and%20click%20Conditional%20Formatting%20%26gt%3B%20Manage%20Rules...%20on%20the%20Home%20tab%20of%20the%20ribbon%2C%20then%20click%20Edit%20Rule...%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello,

 

I am trying to set up some sort of automation to color rows to differentiate orders based on PO#. I have included an example below. We are looking to easily visualize when one PO# stops and another begins. As it stands, this is a manual process but I would love to automate it.

 

As you can see, each PO# is colored in to separate it from the previous PO#'s color by either being grey or white. I don't know how to set up a formula or anything to make excel color a row in this fashion. If anyone can help or offer a solution that would be incredibly helpful.

 

BromanGladiator_1-1637098989532.png

 

Thanks in advance! Looking forward to getting this automated!

 

2 Replies
best response confirmed by BromanGladiator (New Contributor)
Solution

@BromanGladiator 

See the attached version. I created a conditional formatting rule of type formula.

To inspect the rule, select A2 and click Conditional Formatting > Manage Rules... on the Home tab of the ribbon, then click Edit Rule...

@Hans Vogelaar 

 

Thanks so much! This works perfectly!