Prev: moving multiple data in a cell to other columns
Next: Need Help with Sumif Function including dates
From: Q on 30 May 2010 18:21
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
From: Normek on 30 May 2010 19:24
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
From: Ashish Mathur on 30 May 2010 21:28
Which version of Excel are you using

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Q" <Q(a)discussions.microsoft.com> wrote in message
news:D711B211-CCDB-4FB4-BC25-453A8AB4BC29(a)microsoft.com...
> 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

 | 
Pages: 1
Prev: moving multiple data in a cell to other columns
Next: Need Help with Sumif Function including dates