Change color of answer
Yes. This was very helpful and thank you for the additional information.
"Francis" wrote:
Hi Ann
I forget to mention that you need to select the range first before applying
conditonal formatting to the changes in colors based on the conditions you
specified
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"ann" wrote:
I would like to have the color of the answer to a formula change dependent
upon the answer. The purpose is to alert the user to take specific action
when the color of the answer in the cell changes.
ex: if the answer is above 25% then the number in the cell would be green,
if the answer is between 25% and 50% the number in the cell would be blue and
if the answer is over 50% the answer would be red.
Hope this makes sense. Thanks
|