View Single Post
  #2  
Old May 31st, 2010, 12:24 AM posted to microsoft.public.excel.worksheet.functions
Normek
external usenet poster
 
Posts: 35
Default Linking Equations to Highlights

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