What is the excel formula that will change a cell color in column A if column U is "yes"?

I would like a cell in column A change to light red if a cell in column U is Yes. How can I do this? I've read a ton of forums and they all point me to Conditional formating but I can't seem to get it to work. Can anyone help?

1 Answer

Relevance
  • Greg G
    Lv 7
    9 years ago
    Favourite answer

    It is Conditional Formatting.

    Here's what you do:

    Select the cells in column A that you want to change to red if U has a Yes in it, then click Conditional Formatting, New Rule, Use a formula, and enter this as the formula:

    =$U1="Yes"

Still have questions? Get answers by asking now.