Conditional formatting if condition of an if statement is true and a string value is displayed
I got a nested 'IF'-Formula in an excel cell that returns nothing if
the condition is false.
I would like to conditionally format this cell with grey shading if
the condition is true and a string value is displayed.
How can this be achieved using excel conditional formating
Help is much appreciated. Thank you very much in advance.
Let's say your doing this conditional formatting in cell K17. In
conditional formatting (xl2003) choose the FormulaIs: option and enter:
choose your formatt...Commandbar not getting added to inspector when word is used as editor
I have written a Com Add-in which adds a new Commandbar to the New Mai
window. I am using the NewInspector event to place a Commandbar wit
buttons on a new mail Inspector window , I.e. Whenever New Mail messag
window is opened. I have created a new commandbar and aded a ne
commandbutton on that newly created commandbar.
Everything is working fine if i use HTML as mail editor. If i use wor
as the default mail editor in outlook, then the commandbar is no
getting added and also the buttons.
Could someone please suggest me what i should do to add the commandbar
to the word mail editor when ...How do I get Outlook to pick up mail from a subsidiary BT account.
Although I have both my main BT address and my subsidiary BT address set up
under Outlook, it will only get email from the main address. I have to go
into BT mail to read mail on the second account. I had no problems when
using Outlook Express. Any ideas?
Custard Pie <Custard Pie@discussions.microsoft.com> wrote:
> Although I have both my main BT address and my subsidiary BT address
> set up under Outlook, it will only get email from the main address.
> I have to go into BT mail to read mail on the second account. I had
> no problems when using Outlook Express. Any ...Display a SharePoint document library in a Microsoft CRM 3.
I want to display SharePoint documents library in MS CRM3.0 and i did all as
it writen in
but when i try to view the result then no effect on the Case Form.
I need tips for removing error.
1. Log on to your Microsoft CRM server using an account with administrative
credentials. Administrative credentials are required in order to customize a
Microsoft CRM form.
2. Open a browser window and navigate to your Microsoft CRM 3.0 Web site.
3. On the Navigation Pane, click Settings, click Customization, and then
click Cust...How do I get a true calculation? #2
Hi. I think I have just posted this question, but I can't find it now, so my
I need to start at number 1 and multiply it by 2 - then multiply that answer
by 2, then multiply that answer by 2 and carry on until I have done that 480
when I try to do this in excel, I either get the answer 4.72237E+21 (which
means nothing to me) or £4,722,366,482,869,650,000,000.0 which isn't a true
calculation as I have worked it out up to a point, but I dont have enough
spaces on my calculator. Bearing in mind that I have not used excel since I
last worked (about 3 ye...Unable to get TextBoxes property of Worksheet Class Error
I have posted elsewhere to try and get resolution on my issue and decided to
ask for help here as well.
I have an issue that is driving me crazy. I have a workbook that has
multiple sheets and some of these sheets have Textboxes (from the drawing
tool) on the sheet with standard naming (i.e. TextBox 1, TextBox 2, etc.)
I have a button that executes code that takes and builds an external file
with the data from the worksheets, including the TextBoxes. During that
process I am checking to see if those worksheets with TextBoxes have anything
entered before attempting to grab the...Where can I get more toolbar icons?
I want to assign a macro to a custom toolbar button.
When I click Toolbars>Options>Customise>Commands>Macros I only get on
custom button available (a yellow smiley face)
How can I get a selection of buttons to choose from which I can add t
my "personal.xls" workbook and assign various macros to?
Any help would be appreciate
peter_act's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1459
View this thread: http://www.excelforum.com/showthread.php?threadid=26225...display a notification when new mail arrives
Not sure if this is an Outlook or a Windows question! But here goes. Until
a short while ago, I would get an 'unopened envelope' icon in the systray
when new mail arrived, but now its gone.... Don't think I've done anything
to change this - but it was really useful, so can anyone tell me how to put
it back, thanks
Tools, options, preference, Email options, advanced email options, (when new
item arrive in my inbox), mark on show an envelope icon in the notification
(Please respond to this question
Was this post helpful to you?)
Hope this helps you...How do I get charts to ignore results of a formula if it equals 0
Use NA() instead of zero.
Depending on your chart type the point will not be plotted.
Andy Pope, Microsoft MVP - Excel
...How to get query to return total using wildcard
I have a query that has 3 criterion in it as follows: Business Unit,
Location, Category. These criterion are all chosen by the user on a loaded
form. Currently the results then are based on what is chosen from a drop
down list for each of the 3 criterion. The user also wants a total option.
Meaning if Business Unit is chosen, and Location and Category are not chosen
(or if a wildcard is chosen) the result returns a total based on that
Business Unit. How do I write this in the query?
You have to use a union query, one part for details and the other for the
Use cri...OWA Three logins/The Folder can't be displayed
I have an OWA problem where, when any account access OWA, they get three
The email does display in the background but any changing the viewed
folder results in those three login prompts again.
An attempt to delete a message results in those three prompts and then
the user gets a popup "Some items can't be deleted. They were either
moved, already deleted, or access was denied."
Then the inbox no longer displays any messages, instead showing "The
folder can't be displayed. You don't have permission to perform this
Closing and reop...where do i get a SIPOC diagram template?
John... Visio MVP
Need stencils or ideas? http://visio.mvps.org/3rdparty.htm
Need VBA examples? http://visio.mvps.org/VBA.htm
Visio Wishlist http://visio.mvps.org/wish_list.htm
"Carlos" <Carlos@discussions.microsoft.com> wrote in message
On Sun, 26 Nov 2006 16:45:01 -0800, Carlos
>where do i get a SIPOC diagram template?
enter "SIPOC Visio template" gives you...How do I get rid of graphics edge marks that print?
MSOffice2003, Publisher, I'm printing words and graphics. The edges of the
graphics frame that is supposed to not print is printing. I have changed the
order and re-pasting. I have checked to see that "Printer's Crop Marks" is
not checked. Nothing seems to work. The faint line still appears.
Are they your graphics or MS's? Can you tell me which one specifically? Let
me see if I can reproduce it.
MVP Microsoft [Publisher]
"kimberly" <email@example.com> wrote in message
news:ADD4108D-CCF8-421B-A35A-9C9BE82F70E...Images on Forms
Does anyone know if an image can be added to a form? For example, we'd like
to put an image of our 3-party supplier items on their records in the product
I'm currently going down the path of the IFRAME and linking to the supplier
website, but I'd like something cleaner.
I'm on 3.0 currently but will be upgrading to 4.0 soon, so if it can be in
4.0 I can wait.
My suggestion would be to add you image as a note from the related record and
retrieve it at-runtime using client side script (web service call) or any
custom aspx page from a menu entry...How do I get Email send and receive into my primary mailbox?
My email inbox/outbox is in a folder other than personal folders. I would
like to send and receive from the primary mailbox account.
"RGS" <RGS@discussions.microsoft.com> wrote in message
> My email inbox/outbox is in a folder other than personal folders. I would
> like to send and receive from the primary mailbox account.
And what email might that be?
And what do you mean by the "primary email account"?
Outlook sends from the default email account by err, default!
What type of email acct do you ...Getting error with Sample Quote Report in SQL 2000
I have downloaded the "quote, order, Invoice sample report" from
www.gotdotnet.com/codegallery. The reports work fine on my VM (latest
version) with SQL 2005 but it gives a SQL error on another VM with SQL
2000 SP 4. Normal built in reports work fine in this VM. Has anyone
tried these sample reports on SQL 2000. I am desparately trying to
resolve this issue. Our client wants a custom quote in their
application and they are using SBE with SQL 2000.
We have resolved this issue.
We had this problem since we tried to modify the quote report on our
local machine using the ...Get Object ID of selected records
Is there any way to get object ID of all selected records from view. I
need to pass objectId of all selected records to 3rd part site in query
string on button click in CRM.
...Display 4 weeks of data
I am trying to create a query in which data is displayed for the current
month beginning with the first day of the week, first week of the month and
ending with the last day of the week, last week of the month.
In example: Today is Friday June 1, 2007 but the first day of the week would
be Sunday, May 27, 2007. I would like the query to show data between
5/27/2007 through 6/30/2007 -OR- 4/29/2007 through 6/2/2007 for the previous
Does anyone have any ideas?
First day of the current month is DateSerial(Year(Date()), Month(Date()), 1)
Last day of the current month...How do I get the WORKDAY function?
I am trying to translate a successful Lotus 1-2-3 spreadsheet into Excel. It
ain't easy! I typed =WORKDAYS and #NAME? popped up.
This is just one frustration among many I've had with this "leading product"
I don't speak Lotus, but there is an =Workday() in the analysis toolpak (along
Excel's help for =workday() explains how to load the analysis toolpak.
> I am trying to translate a successful Lotus 1-2-3 spreadsheet into Excel. It
> ain't easy! I typed =WORKDAYS and #NAME? popped up.
> This is just one...How to get money to attempt to balace account again
When I got money 2004 Deluxe, first couple of times that I downloaded
transactions, I got this dialogue box that Money was not able to balace the
account. After the second time I checked the box that said something to the
effect "do not attempt to balace account in the future".
How do I get Money to reattempt this again? Would this take a registry
This is for M03: you navigate to Tools > Options > Online Services tab >
check 'Automatically mark accepted transactions as reconciled'. You'll
also need the 'Automatically accept all dow...I can't get SQL Server Express to start
I downloaded it an it was running, then I messed with some setting
sand now it's stopped and I can't seem to get it to run again.
What does the Windows event log say? Did you change the SQL Server service
account, or have you changed your login password? Those are a couple of the
"allenc" <firstname.lastname@example.org> wrote in message
>I downloaded it an it was running, then I messed with some setting
> sand now it's stopped and I can't...Display a range of dates in a calendar
How can I show a range of dates in a pop-up calendar ??
Let´s say I want to show the range between 2010-03-10 and 2010-04-02 with a
different color than the other dates in the calendar. How to do ???
Thanks in advance for Your help
Have a look at the Flex Grid Appointment-Bookings Demo at :-
On Sun, 14 Mar 2010 11:32:01 -0700, Leif Thorsen
>How can I show a range of dates in a pop-up calenda...How to store an image in a xml file
Actually I would like to store an image file(bmp, gif, jpg, ...) in a
So i was thinking about using a UUENCODING or a base64 and
it shouldn't be difficult to do.
<?xml version="1.0" ?>
My problem is to reload this file because once I have read the UUENCODE
and decoded the file I will have a full image in MEMORY.
But ...get "Program File" folder with SHGetSpecialFolderPath on Win98?
I use "SHGetSpecialFolderPath" with "CSIDL_PROGRAM_FILES " tag to get
"Program Files" folder. Everything looks fine until I tested on Win98 with
IE5.5. I only can get "\", not "c:\program files"
On MSDN, I found "CSIDL_PROGRAM_FILES : Version 5.0. Program Files folder.
A typical path is C:\Program Files. "
I clicked "version 5.0", and found :
"Internet Explorer 5 does not update the Shell, so version 5.0 of
Shell32.dll will not be found on Windows NT, Windows 95, or Windows 98
So, how can I get...Subform Not Displaying Datasheet View
I have an unbound subform contained in one tab of a 2 tab control. When the
subform is requery'd after using the RecordSource property, it is displayed
in a form format rather than a datasheet format. Any suggestions on how to
Thanks in advance for your assistance.
Check that you set default view of sub form to datasheet.
Alex Dybenko (MVP)
"AEROTJK" <AEROTJK@discussions.microsoft.com> wrote in message