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

On Wed, 24 Nov 2004 19:26:37 -0800, "DrB" wrote:

Just figured it out using your method. Thank you.

"DrB" wrote in message
. ..
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?

"Dave Peterson" wrote in message
...
Another option would be to use Format|Cells|conditional formatting.

DrB wrote:

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

--

Dave Peterson