SOLVED

New to excel and trying to figure out how to combine cell outputs to determine different row colors

%3CLINGO-SUB%20id%3D%22lingo-sub-1862062%22%20slang%3D%22en-US%22%3ENew%20to%20excel%20and%20trying%20to%20figure%20out%20how%20to%20combine%20cell%20outputs%20to%20determine%20different%20row%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862062%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20making%20a%20spreadsheet%20for%20excel%20and%20am%20extremely%20new%20to%20it%2C%20I'm%20making%20a%20sheet%20with%20a%20series%20of%20drop%20down%20menus%20and%20want%20the%20colors%20of%20the%20rows%20to%20change%20with%20the%20series%20of%20answers%2C%20YES%2C%20NO%2C%20REPLACED%2C%20REPLACE.%20I%20want%20to%20be%20able%20to%20change%20the%20row%20color%20based%20on%20the%20combination%20of%20answers%20provided.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20xx%20is%20yes%20and%20xx%20is%20yes%20and%20xx%20is%20no%20become%20xx%20color%3CBR%20%2F%3Eif%20xx%20is%20no%20and%20xx%20is%20yes%20and%20xx%20is%20yes%20become%20xx%20color%3C%2FP%3E%3CP%3Eetc%2C%20etc%20until%20all%20combinations%20are%20accounted%20for%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Arthianne_0-1604688398945.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231919i18A7E01AE00ECEB3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Arthianne_0-1604688398945.png%22%20alt%3D%22Arthianne_0-1604688398945.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI've%20gotten%20the%20very%20very%20basic%20rules%20done%20like%20this%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Arthianne_1-1604688445362.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231920i003AD0C9837D4964%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Arthianne_1-1604688445362.png%22%20alt%3D%22Arthianne_1-1604688445362.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAnd%20now%20im%20just%20trying%20to%20figure%20this%20out%2C%20any%20help%20is%20greatly%20appreciated%2C%20if%20you%20need%20more%20info%2C%20please%20ask%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1862062%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%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1862193%22%20slang%3D%22en-US%22%3ERe%3A%20New%20to%20excel%20and%20trying%20to%20figure%20out%20how%20to%20combine%20cell%20outputs%20to%20determine%20different%20row%20col%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862193%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F860460%22%20target%3D%22_blank%22%3E%40Arthianne%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20the%20%22And%22%20function%3C%2FP%3E%3CP%3ESee%20the%20quick%20example%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Bennadeau_0-1604690197101.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231927iC84F97FDA7B07A43%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Bennadeau_0-1604690197101.png%22%20alt%3D%22Bennadeau_0-1604690197101.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1862283%22%20slang%3D%22en-US%22%3ERe%3A%20New%20to%20excel%20and%20trying%20to%20figure%20out%20how%20to%20combine%20cell%20outputs%20to%20determine%20different%20row%20col%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1862283%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F703724%22%20target%3D%22_blank%22%3E%40Bennadeau%3C%2FA%3E%26nbsp%3Band%20that%20will%20work%20with%20text%20statements%20as%20well%3F%20not%20just%20numbers%3FEdit%3A%20I%20believe%20I%20did%20it%20wrong%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Arthianne_0-1604692078330.png%22%20style%3D%22width%3A%201246px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231958i876BF808D27474EA%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Arthianne_0-1604692078330.png%22%20alt%3D%22Arthianne_0-1604692078330.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I'm making a spreadsheet for excel and am extremely new to it, I'm making a sheet with a series of drop down menus and want the colors of the rows to change with the series of answers, YES, NO, REPLACED, REPLACE. I want to be able to change the row color based on the combination of answers provided.

If xx is yes and xx is yes and xx is no become xx color
if xx is no and xx is yes and xx is yes become xx color

etc, etc until all combinations are accounted for, 

Arthianne_0-1604688398945.png

I've gotten the very very basic rules done like this 

Arthianne_1-1604688445362.png

And now im just trying to figure this out, any help is greatly appreciated, if you need more info, please ask

6 Replies
Highlighted
Best Response confirmed by Arthianne (New Contributor)
Solution

Hi @Arthianne,

 

You can use the "And" function

See the quick example below.

Bennadeau_0-1604690197101.png

 

Highlighted

@Bennadeau and that will work with text statements as well? not just numbers?Edit: I believe I did it wrong? 

Arthianne_0-1604692078330.png

 

Highlighted

@Arthianne 

Yes. Just place the text in "quotes"

 

Bennadeau_0-1604692141233.png

In your column F and G, make sure there is no trailing spaces at the end of yes and no

Highlighted

@Bennadeau 

Sorry to bore you and take more of your time, I know this is supposed to be basic stuff, I'm making progress but now its coloring all rows, what about the formula do I have to change to make the rule apply to all rows?

Arthianne_0-1604692788801.png

Arthianne_1-1604692821334.png

 

Highlighted

I figured it out, I was seperating them with $ which was causing the issue, Thank you

Highlighted

@Arthianne 

Lol! That was a lot of green! 

No problem, glad I could help.