Forum Discussion

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
Nov 06, 2020
Hi Arthianne,

You can use the "And" function
See the quick example below.

Bennadeau

Iron Contributor

Nov 06, 2020

Hi Arthianne,

You can use the "And" function

See the quick example below.

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
  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
    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?