font color depending upon value possible?

[DrB]

Would like to have calculated cell value from other cells show in black
color if positive and in red if negative. Is this possible?

 

[JE McGimpsey]

If you can't find a suitable format using Format/Cells/Number/Custom's
installed formats, try formatting the calculated cell with

Format/Cells/Number/Custom [Black]General;[Red]General or

[Black]General;[Red]-General

etc.

 

[Dave Peterson]

Another option would be to use Format|Cells|conditional formatting.

 

[DrB]

When using CF it never changes color when I change the cell value. For
example have cell less than ="G4", format is red color, but when cell is
equal or greater than ="G4", then format is black color. Unfortunately the
cell never changes to black when I change the cell value greater than G4.
Why not?

This way changes the cell color. I really want to change the font color. Is
there a way?

 

[DrB]

Just figured it out using your method. Thank you.

When using CF it never changes color when I change the cell value. For
example have cell less than ="G4", format is red color, but when cell is
equal or greater than ="G4", then format is black color. Unfortunately the
cell never changes to black when I change the cell value greater than G4.
Why not?

This way changes the cell color. I really want to change the font color.
Is there a way?

 

[jmb]

Try format/conditional formating.

its very powerfull

 

[DrB]

This way is best since one can copy format and paste on several other cells.
With conditioning format the cell letter doesn't increment to the pasted
cell.

Now is it possible with some cells that never go negative to compare the
value with another and if less than have the font shown in red?

If you can't find a suitable format using Format/Cells/Number/Custom's
installed formats, try formatting the calculated cell with

Format/Cells/Number/Custom [Black]General;[Red]General or

[Black]General;[Red]-General

etc.

Would like to have calculated cell value from other cells show in black
color if positive and in red if negative. Is this possible?

 

[JE McGimpsey]

No, you'll need to use CF for that.

 

[Gord Dibben]

DrB

Try CF>Formula is: =cellref<$G$4

Where cellref is the cell to change font color.

Gord Dibben Excel MVP

When using CF it never changes color when I change the cell value. For
example have cell less than ="G4", format is red color, but when cell is
equal or greater than ="G4", then format is black color. Unfortunately the
cell never changes to black when I change the cell value greater than G4.
Why not?

This way changes the cell color. I really want to change the font color. Is
there a way?

 

[Gord Dibben]

DrB

Would be better if you stuck to the original thread. I posted to that one
before I read this "solved" post.

Waste of my time in my estimation.

Gord Dibben Excel MVP

Just figured it out using your method. Thank you.