D
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?
color if positive and in red if negative. Is this possible?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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.
installed formats, try formatting the calculated cell with
Format/Cells/Number/Custom [Black]General;[Red]General or
[Black]General;[Red]-General
etc.
D
Dave Peterson
Another option would be to use Format|Cells|conditional formatting.
D
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?
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?
D
DrB
Just figured it out using your method. Thank you.
DrB said: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?
J
jmb
Try format/conditional formating.
its very powerfull
its very powerfull
D
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?
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?
JE McGimpsey said: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.
DrB said:Would like to have calculated cell value from other cells show in black
color if positive and in red if negative. Is this possible?
J
JE McGimpsey
No, you'll need to use CF for that.
G
Gord Dibben
DrB
Try CF>Formula is: =cellref<$G$4
Where cellref is the cell to change font color.
Gord Dibben Excel MVP
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?
G
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
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.