[mso] Re: Excel auto color?





A change in rental amounts and leased and available status
Like below if leigh avenue went down in rent fron $795 to $695 I want the
changed item to be highlighted so I can see it at a glance instead of going
through the entire rental list each time
Does that make more sense?
Thanks Lexi

Area    bd/bth  Rent    Address Type    Available
San Jose        1/1     $795.00 Leigh Ave 875 #9        APT     3/19/2003
Sunnyvale       3/2     $1,795.00       Alberta Ave 528 DUP     4/28/2003
Milpitas        2/2.5   $1,650.00       Gingerwood Drive 1453   Condo
4/28/2003
Hi Lexi



Forgive me if I'm a bit dense...I don't understand, what part of the sheet
you want colored, the cell, row or column? and what triggers the change? a
change in totals, a negative number? <paul>
?


>
>
> I asked before but don't seem to get answers to my q's thus 
> far..anywho I know people are busy. So....what I'd like to know is, if 
> it's possible for any changes made to
an
> excel spreadsheet to be auto colored.....ie make a change and it's 
> automatically colored in a color of your choosing.....is that 
> possible? Thanks Lexi
>
>
> ***********


*************************************************************
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 with the word "unsubscribe" (without the quotes) in 
the subject line.

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: