Can you filter or sort by a cell's formatting? #2
Can you filter or sort by the formatting of a cell - these were formatted
manually and do not have conditional formatting applied to them - thanks
You can even use a UserDefined Function that can return the colorindex.
Chip Pearson has a nice function at:
Returning The ColorIndex Of A Cell
If you're new to macros, you may want to read David McRitchie's intro at:
> Can you filter or sort by the formatting of a cell - these were formatted
> manually and do...Windows XP rdp 2008
Estou com problemas a imprimir em RDP 2008.
Em alguns pc's o c�digo de barras aparece impresso com fontes tipo
wingdigs, em outros d� erro de WPF no m�dulo de .net framework 2.0.
Estas mesmas impress�es se forem tamb�m feitas em 2003 j� saem bem .
J� aconteceu a algu�m ? Alguma sugest�o?
O mais estranho ainda � que se as impress�es forem mandadas para
impressoras instaladas localmente (no servidor) em vez das impressoras
capturas pelo rdp este problema n�o aparece.
...Outlook unable to save print settings
I have a Outlook user that, when she chooses to print via
File, print I get the following message; Unable to save
the print settings. Make sure that
c:\winnt\microsoft\outlook\outlprnt exists and can be
written to". It she clicks on the print icon within
outlook it prints fine. I have verified the file and
user rights. Any ideas are welcome!
...Macro for Internet Order Window
I want to create a macro to launch the CTL-SHIFT-F10 "Internet order"
button (because I am going to make a custom button for it). However, I
cannot record the macro because as soon as I hit CTRL-SHIFT-F10, the
order popup window pops up and I cannot end the macro by doing SHIFT-F3.
If I close the window, then hit SHIFT-F3 to end the macro, the macro
just opens and then closes the internet order window.
Is there another way to do it?
No ideas? No one has done this?
> I want to create a macro to launch the CTL-SHIFT-F10 "Int...two sets of parameters..one query...but how?
I have a query to track when I must renew State Police Clearances AND Child Abuse Clearances. I want to use the "Between [date] and [date]" function on BOTH of the fields in order to bring up BOTH sets of dates for BOTH clearances.The problem I am running into is that when the query results come up, if one date doesn't meet the criteria NONE of the information comes up (even if the other date DOES).Any suggestions!??!?! Thanks in Advance....How can I set margins for headers on charts. The margin option ap.
I need indent chart headers to coincide with margins selected fopr the chart
itself. I can not find any control in Excel or printer softeare that will
indent a left-justified header.
As you noted, there is no built-in chart option to indent a left justified
header. I would suggest replacing the header with a text box. You can then
use character spacing within the text box to create the look of an indented
> I need indent chart headers to coincide with margins selected fopr the chart
>...override locale computer settings
I appreciate any help. This is a problem I posted yesterday probably without
being very clear.
How can I override the Windows Regional settings so that my Excel File looks
the same in a computer in Italy and in the Netherlands without forcing the
user to change the Locale Regional settings?
This affects the Date and the Time format, specially within formulas.
Also it seems that the locale setting on Cell Format only works if the
locale is NOT the default.
i.e. A file with the default in UK Eng. and a cell date in Italian and
another in UK Eng, will have the cell in Italian on a Dutch c...Windows Media Player no picture 08-03-10
Vista windows Media Player 11 has sound and visualization but no picture on
some AVI files. One file that does not respond is Fill Handle.exe. AVI
which is a tutorial for Windows Office 2007.
...Windows XP Shared PC
We are using Outlook 2000. The PC, which already had
Microsoft Office 2000 loaded on it, was upgraded from Win
98 to Win XP. I then created Windows XP logons for all
four people that will be sharing this PC. When I did, the
Outlook shortcut automatically ended up on the desktop of
each person when they individually logged in. When I
clicked the shortcut the first time I went in to each
person's desktop, I setup the mail account for JUST THAT
PERSON. And when I go back and log into each person's
desktop it still shows ONLY THEIR ACCOUNT. However,
whatever mail they receive ALS...help with lookup formula (sheet 2, not a double post)
I need to make a formula using a lookup. The first spreadsheet is a
inventory (ALO INVENTORY JP). The second (P&G 103) is a chart tha
tells number of gallons of alcohol per foot/inch/fraction.
On ALO INVENTORY JP I insert the # of feet, inches, and the fraction i
cells R5 and T5. I want these numbers to lookup the number of gallon
off of the P&G 103 worksheet.
For example: P&G 103 (on inventory sheet) is 26ft 4 1/2 inches, i
should look-up to be 34572 gal. for the 26'4" and 55 gal. for the 1/2"
These two numbers should be added together and multiplied by the numbe
...cannot get BCM to work on Office Enterprise 2007 and Windows 7
I have Windows 7 and Office enterprise 2007 and tried to install BCM 2007 and
got it installed then opened Outlook and said it could not setup database. Is
BCM 2007 compatible with Enterprise and Windows 7. Is there a work around?
...Change default view of Activies to Service Activities.
When clicking on any "Activities" tab, CRM shows list of activities of the
object, and it's the view: "Open Activity Associated View".
Can we customize so that the view "Open Service Activity Associated" will be
shown instead? Only show the Service Activities.
Here is something for your interest. Thanks to Michael.
PLEASE do click on Yes or No button if this post is helpful or not for our
uMar Khan :: CRM Freelance Consultant
Email :: imumar at gmail dot com
Blog :: http://umarkhan.word...Default Folder for PST files?
I have a slightly different question relating to the above:
I already have my current & archive pst files stored in my own personal
When I want to open my archive folder I right-click Outlook Today & select
'Open Outlook Data File'.
Everytime, Outlook defaults to its own path (Documents &
Settings\User\Local Settings\Application Data\Microsoft\Outlook\)
This is really annoying & I would like it to default to opening a customised
path, such as C:\Mail\
if you want to displace your pst file, please ...Creating the filter for the recipeint policy
Can you let me know what is the best of way of creating the LDAP filter for
the recipient policy if I want the policy to assign the email address based
on the admin group.This filter should assign the email address to the mailbox
Recipient Policies are based on recipients' attributes - admin group is not
one of them.
Perhaps look at other common attributes, or add an additional UPN suffix and
assign a common UPN suffix to these recipients, than use Recipient Policies
to filter based on UPN.
MVP - Exchange
NEW blog l...Help on filter
I have a list to filter. I have to keep only integers.
I tried everything in advanced filters... does not work.
Can you help me please?
Message posted from http://www.ExcelForum.com
one way: use a helper column. Lets say your numbers are in column A
then enter the following formula in an adjacent cell for row 2
copy this down for all rows. After this filter with this helper column
> I have a list to filter. I have to keep only integers.
> I tried everything in ...Lookups across worksheets
I need to consolidate some information, using several worksheets in one
file. Here's an idea of what I need to do:
WORKSHEET 1 - [/B]
BILL | SMITH | 1 | 3
JEN | JONES | 2 | 1
[B]WORKSHEET 2 -
1 | Acme
2 | Widgets
3 | Bucky's
WORKSHEET 3 -
1 | New York
2 | Paris
3 | Rome
I need to come up with a set of formulas that give me the following
WORKSHEET 1 -
_F...Microsoft publisher, how do I set it to show multiple pages?
I'm trying to show more than one page in a single viewing pane. As in for the
use of a banner. You'd think that'd be a simple and accesable function. I
don't see it anywhere...
Print preview has this function. Not sure if this is what you are asking...
Mary Sauer MSFT MVP
"BrickShort" <BrickShort@discussions.microsoft.com> wrote in message
> I'...Windows Installer Configuration EVERY TIME!!!
Ok, so I am sure this sounds pretty familiar. Every time I open an office
application, or an office document, I get a pop up of the windows installer
and it starts running some mystery configuration process. I have tried
uninstalling/reinstalling. I have tried repairing the registry permissions.
I have ripped all office traces out by force and done a clean install. I
have rebuilt the registry, modified it, added some conditional entries, but
to no avail. I have done it in the user account, and the built in
administrator account. I have done both custom and full installs. ...Page set up #2
I want to use the paper size of A3, but cannot find it in the paper options.
Anyone know where I can find it?
Check your printer properties and preferences. If the printers you have
installed won't handle A3 you won't have it. And you will need to
"install" something that will. Even a "PDF" file printer will do.
Alan Badgery wrote:
> I want to use the paper size of A3, but cannot find it in the paper
> options. Anyone know where I can find it?
I've just a home use computer, but the intention was to use the work book
between and home and work, w...How to stop RichEdit color change overriding default color
I've got a handly little syntax editor going along (that--so far-- is
waaay faster than the examples on codeguru.com (if you'd like to know
how to speed them up, I spotted a logic flaw in two of them. If
you're interested, just email me). I have a question on a different
syntax editor I'm writing for an in-house language though, so you'll
notice some unique features that enable me to take shortcuts.
But I've got a funny little problem. If the user is typing at the end
of the rich edit control, and they type in a keyword and it gets
colored, any text typed after tha...Override font setting
Can I override font setting when read a received email
Because some font style very hard to read when received
and I have to change font style one by one (sometimes
cannot change) Thanks!
...How do I get a filter to "UPDATE" the rows selected?
I am using Excel 2002 and I have a speadsheet that has prices in it.
If I have the filter set to (the filter criteria is much more complex than
this though) prices for items that cost >$5.00.
Of I change an item to 4.59, it should not be seen. How can I get it to
re-update the rows shown, with out releaseing the filter and resetting it?
Is there something like refresh.filter or anything like that?
AFAIK you must release and reset but a macro with a worksheet_change event
could trigger this for you so that it would happen automatically.
SalesAid...Switching between multiple open windows
I ran across an option to change how to switch between multiple open windows
on my desktop. It was an option to choose between hovering over a window or
clicking on it. Thinking that only having to hover over a window to switch
to it would save time, I selecting the option to hover... big mistake as it
just became a big pain in the a_ _ for me. Now I would like to change back
to one-clicking to change between viewed windows but can't remember or find
where the option is located. Any help will be appreciated.
On 2/03/10, rushl posted:
> I ran across an opti...Only printing header in Windows Live Mail
My canon printer has suddenly stopped printing the email content - only the
Printing in word, excel etc not affected. Using W7 (+ Firefox if that
Any suggestions please
Does you have the same problem if you try printing from IE? WLM depends
on IE for printing services.
Take a look at this:
Print and Print Preview May Display Only Text at Top of Page
It's a similar problem for a different version but the fix may apply.
Mike - http://TechHelp.Santovec.us
"Jem" <Jem@discussions.mic...Outlook pop up windows stops outgoing mail
In the last 3 weeks I continue to get a pop up window
titled "Enter Network Password". There is a key icon and
the request: "Please type your user name and password."
It then list my
Password: (entered with asterisk showing)
I continually enter my Outlook password with Bellsouth
and click the box "Save this password in your password
list" and click "OK".
Everything then works alright and then the window pops up
again in 5 minutes. It happens over and over again.
Anybody have any ideas on how to eliminate this? I use