SOLVED

Conditional Formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2041161%22%20slang%3D%22en-US%22%3EConditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2041161%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Conditional%20Formatting%20to%20fill%20colors%20in%20a%20row%20based%20on%20the%20text%20of%20one%20of%20the%20cells%20in%20that%20row.%26nbsp%3B%20There%20are%20two%20options%20that%20will%20be%20in%20the%20cell%20to%20be%20analyzed-%20Stub%20or%20Chain.%26nbsp%3B%20I%20want%20a%20the%20cells%20in%20the%20range%20of%20cells%20A%3AI%20to%20be%20blue%20for%20%22Stub%22%20and%20yellow%20for%20%22Chain%22.%26nbsp%3B%20I%20have%20set%20up%20the%20formulas%20and%20formatting%20as%20I%20have%20done%20in%20the%20past%2C%20but%20now%20Excel%20is%20only%20formatting%20one%20of%20the%20cells%20in%20the%20range%20and%20not%20the%20whole%20range.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20Rules%20window%20I%20created%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ronmazz1959_0-1610046470217.png%22%20style%3D%22width%3A%20612px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244781i2525C1DB673D5088%2Fimage-dimensions%2F612x222%3Fv%3D1.0%22%20width%3D%22612%22%20height%3D%22222%22%20role%3D%22button%22%20title%3D%22ronmazz1959_0-1610046470217.png%22%20alt%3D%22ronmazz1959_0-1610046470217.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20the%20spreadsheet%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22ronmazz1959_1-1610046516082.png%22%20style%3D%22width%3A%20618px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244782iD2E79E3A11CD4F5C%2Fimage-dimensions%2F618x184%3Fv%3D1.0%22%20width%3D%22618%22%20height%3D%22184%22%20role%3D%22button%22%20title%3D%22ronmazz1959_1-1610046516082.png%22%20alt%3D%22ronmazz1959_1-1610046516082.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20anyone%20else%20experiencing%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2041161%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2041503%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2041503%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921537%22%20target%3D%22_blank%22%3E%40ronmazz1959%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20just%20need%20to%20change%20the%20formula%20in%20the%20%22%3CSTRONG%3EConditional%20Formatting%20Rules%20Manger%3C%2FSTRONG%3E%22%20for%20both%20rules%2C%20just%20add%20the%20%24%20in%20front%20of%20the%20column%20name%3C%2FP%3E%3CP%3E%3D%3CSTRONG%3E%24%3C%2FSTRONG%3EH8%3D%22Chain%22%3C%2FP%3E%3CP%3E%3D%3CSTRONG%3E%24%3C%2FSTRONG%3EH8%3D%22Stub%22%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22con1.png%22%20style%3D%22width%3A%20612px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244798iB52A0E704083D345%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22con1.png%22%20alt%3D%22con1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20If%20my%20post%20helped%20you%2C%20please%20click%20on%20like.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2044451%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2044451%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921537%22%20target%3D%22_blank%22%3E%40ronmazz1959%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGlad%20it%20worked.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am using Conditional Formatting to fill colors in a row based on the text of one of the cells in that row.  There are two options that will be in the cell to be analyzed- Stub or Chain.  I want a the cells in the range of cells A:I to be blue for "Stub" and yellow for "Chain".  I have set up the formulas and formatting as I have done in the past, but now Excel is only formatting one of the cells in the range and not the whole range.

 

This is the Rules window I created:

ronmazz1959_0-1610046470217.png

 

This is the spreadsheet:

ronmazz1959_1-1610046516082.png

 

Is anyone else experiencing this?

 

4 Replies
best response confirmed by ronmazz1959 (New Contributor)
Solution

@ronmazz1959 

 

You just need to change the formula in the "Conditional Formatting Rules Manger" for both rules, just add the $ in front of the column name

=$H8="Chain"

=$H8="Stub"

con1.png

 

* If my post helped you, please click on like.

Thanks- that worked!

@ronmazz1959 

 

Glad it worked.

Hi all how do we copy and paste a conditional format with rules to another cell and update the rules accordingly automatically? I am having to go into each cell and manually update the rules to coloborate with the corresponding cell?