dynamic color changing within cells

  • Thread starter Thread starter Tom Donino
  • Start date Start date
T

Tom Donino

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?
 
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.
 
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
 
Back
Top