Hi there, I'm sure this a very basic question, but I need to change the color of a cell based on the result of a formula. If the result is 4, then it should turn purple, if it is a 3, then it should turn yellow, a 2, then green, and a 1 turn red.
For the LIFE of me, I cannot get anything to work!! >:\
Thank you so much for your help!
~Katherine
@katherinew
The attached file has some basic formatting rules. See if you can apply similar rules to your own data. If not, come back here and include your file so that we can provide a solution that will work for you.
The formatting in the file didn't change any of my cells... I have attached a copy of my worksheet below... it makes no sense??
Your formulas return either "1", "2", "3" or "4". The quote marks turn these values into texts whereas the conditional format looks for numbers 1, 2,3 or 4. Remove the "" in the formulas or change the formatting rules to look for "1", "2", "3" or "4". Then it shall work.
@riny You are awesome! That worked just fine, thank you so much!