Conditional Formulas and finding lower numbers in a series
I am trying to create a conditional formula which can show a keyword in a
cell - if the values in a set of cells has three values under 'x' amount.
Is this possible??
"chrysler265" <email@example.com> wrote in message
>I am trying to create a conditional formula which can show a keyword in
> cell - if the values in a set of cells has three values under 'x'
> ...IF with icon or similar
How I show a picture or icon when the value in a cell> 50 and other icon or
picture when <= 50 ?
I don't know how your getting the number 50.
Iif it is from a formula result, right click on the Worksheet tab View
Code: and paste this code in: This assumes there are 2 pictures on the
sheet. one named "Pic1" and another named "Pic2". Change these names
accordingly, either in the code or the pitures on the sheet. This also
assumes that the cell that will have the 50 is cells B1 (Row1,Col2 =
Cells(1,2)) change this to the correct cell.
O...Find a name...very urgent
I have a big list of clients. Usuallly don´t know all name when I search,
sometimes is the first name, middle, last... The name is in a unique field
that I can´t change. In a form, I want to write one name, for example Mary,
and have a list with all names that have Mary. Then I write Brown and have a
list with all names with Mary and Brown, and so on till the person I reallly
In query design view, below the name fieild, in the Criteria row, type this --
Like "*" & [Enter name] & "*"
When you run the query it wil...Back up and restore of Out look express.
I backed up my "document and settings" and would like to get my address book
restored in Outlook Express. Do you know what extension the Address book
is? Can I import it? Thanks
Try posting this in an Outlook Express news group - this is not one of them.
Outlook is a part of Microsoft Office and is what this group supports.
Outlook Express is a part of Internet Explorer and has its own news groups.
You can also find some good Outlook Express information here:
Milly Staples [MVP - Outlook]
Po...Outline format in Excel
How can I create a list of items in a cell? And how can I tell Excel where to
wrep-around? So want something a cell that looks like this
2. Body of Text
I'll want to repeat that in a number of cells. I know that I have to change
the cell height? But how do I get it wrap so it looks the way I want it?
> How can I create a list of items in a cell? And how can I tell Excel
> where to
> wrep-around? So want something a cell that looks like this
> 1. Introduction
> 2. Body of Text
> 3. Conclusion
> I...Excel VBA
I tried to add a menu item under Tools menu item according to the Add-In
example in "Microsoft Office Excel 2003 Bible" book, chapter 40,
"Creating Custom Excel Add-Ins". And yes, I use Office 2003 Standard.
I got the Add-In working as a macro - that is, a new form appears having
various checkboxes for different settings (e.g. gridlines on/off,
row/column headers on/off etc.). And these are working, too.
However, using the following Sub does not work = the Toggle Settings...
menu item does not appear under Tools menu item.
Additionally, now my Tools menu ite...Problems with Redeployment tool
I need to redeployment one CRM that has 150 users in another that ony
has 10 users.
I do all the necesary steps that Microsoft recomended but when I
choose "manual mapping" for users and I establish the relation betwen
old and new users the Redeployment tool doesn=B4t make anything.
Nope, you have to have an equal number of users and the same kinds of
licenses on both systems. It's a requirement in the redeployment guide.
"Novel" <firstname.lastname@example.org> wrote in message
news:email@example.com...Windows can not find my spreadsheet
I repaired and uninstalled then installed Office 2007. I opened Excel up and
search for my Excel Spread Sheet and open it and then save as on my desktop
like I always do. Then when I double click on the Icon I get "Windows can
find C:\User etc. Make sure you typed the name correctly, and then try
again. Any excel spreadsheet I have I get the same message when I double
click on it. I check the path and it is correct.
Check your other post.
> I repaired and uninstalled then installed Office 2007. I opened Excel up and
> search for my Excel Spread Sheet an...LOST EMAIL ICON
WHEN I SWITCH IDENTITY ON OUTLOOK EXPRESS I LOOSE THE
ICON AND I NEED TO RESTART THE COMPUTER WHY?
Don't use CAPS!!!
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is the link for the right forum
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Backup and Restore
-Create an Office XP CD slipstreamed with Service Pack 3
"VIC" <anonymo...Change ServerURL but Outlook doesn't like it!!!
I of course had the default setup http://server:5555. I'm actually staying
with the port 5555 but the address is changing due to publishing it through
ISA 2004. I have http://crm.domain.com:5555 setup and I can use CRM through
IE without a problem. I've already updated the registry keys on the server
to the same. I also set serverURL and webURL on the client PC to the same
path. Outlook just doesn't connect. I've reboot a few times. I saw
instructions that said to also update platformURL as well, but that path is
a local directory, i'm guessing because its a ...Service tools
how can i see all my service calendar appointements in
exchange server shared forders agenda.
That way i could see may agenda in several viwes and i could print it.
Pedro Oliveira - Portugal
...Google developers kicking our @sses again. Look at this...
Google has implemented integration with Twitter feeds in an iFrame returned
with search results.
search: ces 2010
Observe the 5th or so result "Latest results for ces 2010- Pause" and see
why these guys are clearly becoming the most advanced and sophisticated
developers on the planet when it comes to innovation. I only bring this up
because its getting embarassing we're so far behind in all that matters to
the customers that would hire us.
So the question here is what are you saying to savvy customers to win
projects these days?
shit for brai...Find Discrepancies between Worksheets
I have 2 worksheets that should be identical (merged cells, colors/borders,
number formats...), but when I try to paste values from one to the other, it
kicks it out because merged cells are not identically sized. Obviously,
there is some discrepancy in the thousands of cells of formatting.
Is there a way to compare the 2 worksheets and come up with a list of what
It's a long story why I can't just overwrite the one, but please just trust
that one sheet cannot be changed at all and the other is an output from a
database that I do not have access to and so have ...HITB Reset Tool
Working with a client to the get the HITB installed and running.
They are on GP 10 SP 2 using SQL 2000.
When I run the script to generate the stored procedure need for the rest
tool it doesn't run and I get errors.
I can run the same exact script on a SQL 2005 instance.
Is the script not supported on a SQL 2000 database.
Any help will be appreciated.
...DirSync of Novell Connector, doesn't find existing users
DirSync of Novell Connector, doesn't find existing users
...system tray new mail icon gone :(
Before i used to have an icon pop up in my system tray when i received a new
mail. I accidently hid it one time and it no longer comes back. How can i
get it back. I run Outlook Xp on a Win XP pro machine.
Thanks in advance..
Check Tools, Options, Email Options, Advanced Email Options. MAke sure the
checkbox for "show an envelope in the notification area" is checked. If it
is, right click on the Windows taskbar. Choose Properties, then customize.
Your icon might have just been set to always hide. If so, you can change it
to always show.
Outlook...IDictionary. Find value
I have a IDictionary<Int, String> Contraints.
How can I find if there is a Value (not a key) in this Dictionary
which String contains the word "text" in it?
> I have a IDictionary<Int, String> Contraints.
> How can I find if there is a Value (not a key) in this Dictionary
> which String contains the word "text" in it?
You have to search all the values.
In general, you should avoid designing code with a requirement like
that. It has obvious inefficiency problems, and...Can I create an outline form numerical Outline Level?
Further to my posting 'Can I copy row grouping between files?'
In my Excel file containing data exported from MS Project there is a column
headed 'Outline Level', containing numbers 1 > 8.
How can I use these to create an outline to group rows in the excel file?
...FBI FORENSICS CAN FIND DELETED FILES xxxaaaaaaaaaaaassssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssaaaaaaaaa\aaaa
You're in Serious Trouble - It's a Proven Fact!
FBI FORENSICS CAN FIND DELETED FILES
THERE ARE THINGS ON YOUR COMPUTER
THAT YOU THOUGHT YOU DELETED.
!!!!BUT THEY ARE STILL THERE!!!
Click here for details on the EVIDENCE ELIMINATOR
Clear your computer of incriminating files
that you cannot delete.
THIS IS A MUST READ!!!!
...0.947694 Look Inside And Realize That Dream ... 0.2828604
1.178199E-02 Look Inside And Realize That Dream ... 9.059644E-02
0.947694 Now Visit http://nowclickhere.bravehost.com/index.html 0.2828604
...PST Discovery Tool
Can anyone recommend a utility or script that can be used to remotely
discover PST files on workstations? I am looking for a centrally managed
solution. The PST files on the workstations are not lost. At the very
least, this tool should tell me who has a PST file attached to Outlook.
There is one included in the PST Migrator part of KVS (aka Symantec
Enterprise Vault). Realistically you're looking at the output of dir /s
*.pst on each drive on your PCs...
Windows Server MVP - Directory Services
"jason c" <jason c@disc...Look for: Search In does not reveal in which folder an email is found located
When I search for an old email using Outlook's Look for: box and specify
which folders to search in via the "Choose folders=>Search subfolders" , I
am unable to see in which folder a particular email was found from the
resulting list of emails. How can I tell in which folder the email I'm
looking for was located?
Santa Monica, CA USA
To email me, just pull 'my-leg.'
...CRM 3.0: Report icon disappeared
I am facing a major problem: The reports' icon for most of my users
disappeared! A couple other people and myself are Admins and we can
still access reports OK. The other users cannot see the report icon
from the Accounts form, for example. When they access Reports under My
Work, they get a blank form instead of the list of all reports.
The only things I remember changing since it was last working are:
- Rearranging most users in business units and changing which BU was
parented by which.
- I published the reports using VS2003 so now they are visible from
http://crm-server/report...Creating Icons as a Resource
I have a few questions about creating a icon as a resource in VS 2003.
In order to create a icon to be used as a resource in Win95, Win98,
Win2K, WinXP do I need to create a image for every Target Image Type
(16X16 16 Color, 16X16 256 Color, 32X32 16 color, 32X32 256 color,
This application will be released to a large audience.
Are there any other things I need to know about the icon format that
may be useful to a novice?
Thanks for all the help!
48x48, 256 color
32x32, 16 color
16x16 pixels, 16 color
"Solomon_Man" <solomon_ma...Close MSN Instant Messenger Taskbar Icon in Inbox?
Icon appear at lower right next to clock every time I go
to my Inbox. How do I make this go away permanently?
In article <firstname.lastname@example.org>,
> Icon appear at lower right next to clock every time I go
> to my Inbox. How do I make this go away permanently?
Use Startup Control Panel by Mike Lin. It is a small freeware app that
allows you to easily remove Messenger very simply. I swear by it for
removing all things that push themselves into the registry without