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

Question

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?

Answer 1

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"