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