I am trying to enter some text to a cell based on the text in a different cell with Conditional Formatting.
For example, I want cell A1 to have "YES" entered into it when cell A5 has the letter "Y" typed into it.
I don't want to use a formula in cell A1 since I will be typing other items in it...