View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_8_] Nigel[_8_] is offline
external usenet poster
 
Posts: 172
Default dynamic color changing within cells

Tom,

In the spreadsheet use the conditional formatting command for the range
involved.

Set the condition to cell value greater than 0 and Format Font Color Blue
Set another condition to cell value less to 0 Format Font Color Red

If you have set the cell to default Black then a 0 will remain black

If you need to do this in VBA let me know

Cheers
N


"Tom Donino" wrote in message
...
How can I get the numbers in a cell to change color
depending on whether or not they are positive or negative
as in a stock price change?





----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---