Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic color changing within cells
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
dynamic color changing within cells
This can be done easily by use of "Conditional formatting"
Click in the cell you want to change color. Click on Format. Click on Conditional formatting. Excel allows use three "conditions" that you can specify a change in cell format -- color, font, and border. Use the drop downs. In your case it will be easy. Just sellect "cell greater than" and enter "0" as one condition -- then specify your format change. Click Add sellect "cell less than" as your second condition and specify the format. Click ok Now double-click on the "Format Painter" button (looks like a yellow paintbrush) and then highlight all other cells that you want formatted that way. *** If you use a formula to change the color in a cell, e.g. using nested If functions, Excel by Default will enter "$" to make the conditional format unique to that cell. Remove these before using the format painter to apply the same format to other cells. Cheers. --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 =--- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing the color of cells by formula | Excel Worksheet Functions | |||
Changing several cells text color | Excel Discussion (Misc queries) | |||
color changing of cells | Excel Discussion (Misc queries) | |||
Changing color on a range of cells | Excel Programming | |||
Changing color of cells | Excel Programming |