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?
- Greg GLv 79 years agoFavourite 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: