View original (French)

Conditional formatting

Solved
RAF26ML -  

Hello,

I am trying to create a conditional formatting rule in a table where I have created a dropdown list in the cells of column I, and I want to color the entire row green when an option is selected.

Can you help me, thank you very much.

3 answers

  1. danielc0

    Hello,

    1. What do you call an elevator?

    2. Formatting should be done from which column to which column?

    Daniel

    1. RAF26ML Author

      What do you call a dropdown? dropdown created with data - data validation = list

      What columns should the formatting apply from and to?

      On the entire concerned row - table from column B to AY, the column with the dropdown is column I

      Thank you

    2. RAF26ML Author
      @RAF26ML

      drop-down list = sorry I didn't use the right term

    3.  DjiDji59430
      @RAF26ML

      Hello,

      - - - An EXCEL file (test or not), complete with exhaustive explanations and hand-filled examples (if needed), uploaded to https://www.cjoint.com/, as well as your version of Excel, would allow the participants to respond more accurately to your question. Don't forget to provide us with the link!
      Best regards

  2. danielc0

    We generally talk about a validation dropdown list or a validation list. Select the first cell of the table. Create a conditional formatting rule with the formula for example (here 8 is the first row of the table)

    =$I8<>"" (note the "$" in front of I)

    Choose the formatting of your choice

    In the "Applies to" field, select the data from your table.

    Daniel

    Daniel

    1. RAF26ML Author

      OOPS, I finally found it in the conditional formatting with the formula

      on the forum, thank you

      =$I4<>""

      I'm marking it as resolved.