[mso] Re: Excel 2000 - question

It might work if you can have more than 1 set of freeze panes.  Right now I 
have column heading rows frozen across the top.  If I could freeze pane that 
column too the I wouldn't need the color change deal becaue I could visually 
monitor it.  It's because it's umpteen columns past the usual work area that 
I was looking for a way to alert me. But I understood you could only have 
one freeze pane.  Tis not true?

Pam 

Linda Johnson writes: 

> 
> Well....you could a formula to total that column in cell A1, click in B1
> and go to the Window menu and freeze panes....then column A will always
> stay on your screen....then you could use conditional formatting to make
> A1 always appear in red or something whenever it goes below 0 and blue
> when it goes above 0 
> 
> Would this work? 
> 
> Linda
> Publisher ~ ABC ~ All 'Bout Computers
> Owner ~ Linda's Computer Stop
> http://personal-computer-tutor.com
> FREE MS Office eBook Tutorial
> http://personal-computer-tutor.com/library.htm
>   
> 
> 
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf Of Pam
> Sent: Friday, June 28, 2002 2:18 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Excel 2000 - question 
> 
>  
> 
> 
> Is there a way to make Excel show an alert or sound or something,
> anything 
> would be ok, if the results of a given column isn't within a specified
> range 
> (in this case greater or less than zero).  This field I need to monitor
> is 
> one that is not generally within the viewing area of the columns I'm 
> inputting data into.  
> 
> Pam 
> 
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
> MicrosoftOffice@xxxxxxxxxxxxxxxx 
> 
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx 
> 
> To Unsubscribe from this group, send an email to 
> mso-request@xxxxxxxxxxxxx?Subject=unsubscribe 
> 
> Or, visit the group's homepage and use the dropdown menu.  This will also 
> allow you to change your email settings to digest or vacation (no mail).
> http://www.freelists.org/webpage/mso 
> 
> To be able to use the files section for sharing files with the group, send a 
> request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation 
> with instructions.  Once you are a member of the files group, you can go here 
> to upload/download files:
> http://www.smartgroups.com/vault/msofiles
> *************************************************************
 
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: