Forum Discussion

Arthianne's avatar
Arthianne
Copper Contributor
Nov 06, 2020
Solved

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

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, REPLA...
excel
Formulas and Functions
training
  • Bennadeau's avatar
    Bennadeau
    Nov 06, 2020

    Hi Arthianne,

     

    You can use the "And" function

    See the quick example below.

     

Arthianne's avatar
Arthianne
Copper Contributor
Nov 06, 2020

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

 

Bennadeau's avatar
Bennadeau
Iron Contributor
Nov 06, 2020

Arthianne 

Yes. Just place the text in "quotes"

 

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

  • Arthianne's avatar
    Arthianne
    Copper Contributor
    Nov 06, 2020

    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's avatar
      Arthianne
      Copper Contributor
      Nov 06, 2020

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

      • Bennadeau's avatar
        Bennadeau
        Iron Contributor
        Nov 06, 2020

        Arthianne 

        Lol! That was a lot of green! 

        No problem, glad I could help.

Resources