Conditional Formatting Font color change

Options

Hello,
Is there a way to change the font color of a single items in a dropdown list on the specific column only and not apply the font color change to the entire row?
Thank you!
TaliN

Best Answer

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 07/03/24 Answer ✓
    Options

    @TaliRXM,

    Yes! When setting up your conditional formatting rule, click "entire row" and select which column(s) you want the value of to be a different color. You can pick just one column, and if the criteria is for a certain value then only that value in only that column will get the format applied to it.

    BRgds,
    -Ray

Answers

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 07/03/24 Answer ✓
    Options

    @TaliRXM,

    Yes! When setting up your conditional formatting rule, click "entire row" and select which column(s) you want the value of to be a different color. You can pick just one column, and if the criteria is for a certain value then only that value in only that column will get the format applied to it.

    BRgds,
    -Ray

  • TaliRXM
    TaliRXM ✭✭✭
    Options

    Thank you!

    Works well!

    Best,

    Tali

  • MarceHolzhauzen
    MarceHolzhauzen ✭✭✭✭
    Options

    Hey @TaliRXM

    You are not able to change the actual colour of the dropdown option, but if you use the conditional formatting to the choice selected, you could apply it to the one cell only.

    Marcé Holzhauzen
    Dare to try

    If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.