View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ann ann is offline
external usenet poster
 
Posts: 210
Default 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