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

Ann
Look in Help under Conditional Formatting. HTH Otto
"ann" wrote in message
...
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

Thank you. This is most helpful

"Otto Moehrbach" wrote:

Ann
Look in Help under Conditional Formatting. HTH Otto
"ann" wrote in message
...
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

Hi Ann

Perhap you want Green if cell value is less than 25?
try this
Go to Format on the Menu bar
select Conditional Formatting

Condition 1 :
if cell value is less than type 0.25 click format choose green
color

Condition 2 :
if cell value is between type 0.25 type 0.50 click format
choose blue color

Condition 2 :
if cell value is greater than type 0.50 click format format
choose red color

--
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

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

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