LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
ann ann is offline
external usenet poster
 
Posts: 210
Default Change color of answer

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add color to the formula answer israel New Users to Excel 2 October 31st 08 05:33 AM
changing color of answer gman1964 Excel Discussion (Misc queries) 1 February 20th 08 10:06 PM
font color for formula answer Judson Excel Discussion (Misc queries) 2 March 23rd 06 07:22 PM
How can I change the color of an "IF" function answer? Elmo? Excel Worksheet Functions 2 February 26th 06 06:06 PM
how do i get answer is 1 from CELL("color",sth) function? T.Thinh Excel Discussion (Misc queries) 1 June 24th 05 10:07 AM


All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"