View Single Post
  #3  
Old May 31st, 2010, 02:28 AM posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_]
external usenet poster
 
Posts: 1,764
Default Linking Equations to Highlights

Which version of Excel are you using

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Q" wrote in message
news
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