I am interested in linking a formula to the colour of the cell. Ie. positive
number would produce a green cell & negative cell would high light the cell
in red.
The reason of the question is that I can do a financial report that
automatically tells me if a catagory is in the negative or in the positive at
a glance.

Thank you

Hi Q,

Just use conditional Formatting. Look it up in help.

--
Normek


"Q" wrote:

I am interested in linking a formula to the colour of the cell. Ie. positive
number would produce a green cell & negative cell would high light the cell
in red.
The reason of the question is that I can do a financial report that
automatically tells me if a catagory is in the negative or in the positive at
a glance.

Thank you

Which version of Excel are you using

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Q" wrote in message
...
I am interested in linking a formula to the colour of the cell. Ie.
positive
number would produce a green cell & negative cell would high light the
cell
in red.
The reason of the question is that I can do a financial report that
automatically tells me if a catagory is in the negative or in the positive
at
a glance.

Thank you