Changing color of text based on formula result
It' tough getting old. Can someone please refresh my
memory as to how you change the color of a cell's contents
based on the result of the formula? Thanks.
Conditional Formatting is what you're after.
Take a look here for examples:
> It' tough getting old. Can someone please refresh my
> memory as to how you change the color of a cell's contents
> based on the result of the formula? Thanks.
...Knowledge Base and font size
I am really frustrated with the knoeldge base in CRM. While on the one hand
it makes sense to use it there are many short commings arround it (no
attachments, customization, etc.).
One big problem I currently have is, that when I paste an entry from the
knowledge base into an email the fonts of the article text are huge (like 12
px or more). I was able to change the size of the title and everything, but I
do not find any way to change the size of the article text.
If anyone has an idea on that I would really appreciate it.
...I need to filter based on colour
Hello I have a spreadsheet of Excel 2003 in which in one column (column B)
there are entries coloured yellow and some with no colour (white). I need to
filter and see only the yellow entries . But I need to filter all the
columns of the spreadsheet based upon the yellow colour of column B. So I
can see all the information in every other column of those yellow entries of
Can someone help me?
Unless all the yellows are derived from the same formula for a custom
autofilte then you would need to have a for each loop macro that hid the non
Don Guil...How to change the colour of a cell(s) based on cell value
I am stuck on this rather simple problem. Could not find any hel
I want to change the colour of a cell to green if the vallue is = Tru
and to red if it is False.
I have tried to use the Conditional Formating but without joy.
Artful Dodger's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1656
View this thread: http://www.excelforum.com/showthread.php?threadid=32059
select the cells
choose format / conditional formatting
cell...Knowledge Base 929445
Hey everyone. Does anyone know what changes are made in the GP update
outlined in KB929445 (to version 9.00.0291)? The updates page lists this as
the KB number for the update, but after almost a month of waiting there is
still no information posted on the web. We need this update to update the
Canadian Payroll tax tables, but the number of modules affected by it is
extensive. We need to know what is affected so we know what we should be
testing. Any information would be helpful.
...Combine 2 data bases
I have designed 2 seperate data bases relating to Finances that have 2 Bank
Accounts/Statements. They are both very similar. Is there a way I can link
the 2 for the purpose of designing reports etc.
Thanks for any help
You can design (yet another) database , which uses links to the tables in
your two existing databases, and build the reports in that database. To do
so, use the File | Get External Data | Link Tables ... menu item in the new
But why would you want to? Why not simply merge your two existing databases
into one, rather than producing a third one? That's ce...web-based MSN Money
Is the web-based version of Money equal in performance and ability to
regular Money Deluxe? Has anyone used it? Pros? Cons?
...LDR: Dll xy.dll base 100000 relocated due to collision with yx.dll
as posted before i was wondering why my app coused 100% CPU-usage on WinNT
and 0% on W2K/XP - i figured out that this could have to do with
those dll relocations because almost every dll used by my app gets
most of the dlls have a collision with one single dll of my own others have
a collision with the exe itself.
how to solve this?
You can change the default base address using project
"Philipp Huber" <firstname.lastname@example.org> wrote in message
news:email@example.com...Backup and Restore Registry Knowledge
I would like to know how to BACKUP a good registry, say the first one
after a complete factory restore. AND THEN, if in the future I wanted
that same BACKUP restored, pristinely, without any later additions of
programs, registry entries updates and such. In other words, the same
registry I saved after a factory recover, would be RESTORED.
How can such a thing be accomplished? Thanks, jack
"jack0233" <firstname.lastname@example.org> wrote in message
> I would like to know how to BACKUP a good regist...How to add amount to a cell based on category and month
I have a list of expenxe categories and by month along the top. How can I
write the sumif function based on two criteria from drop-down list(one list
is Expenses and the second list is the Months) and the third (Amount) cell
would be where I input an amount to be added into the table:
Expenses month amount
Fuel JAN _______
Expenses JAN FEB MAR
so many functions...!?!?!?!?!?!?
If you are trying to fill a matr...Custom base class for dialog
I have a base class derived from CDialog, let's call it CMyDialog.
CMyDialog implements basic functionality that a large group of my
dialogs need to have. One common member is a CGridCtrl (another derived
class), that implements subitem editing.
My issue comes to having handlers that respond to LVN_BEGINLABELEDIT as
well as LVN_ENDLABELEDIT. To use the message map functionality I need
to have some identifier such as IDC_LIST1. The problem of course is
that CMyDialog doesn't have access to this value. The other problem is
that perhaps the CGridCtrl members doesn't have the same dia...hive based registry + gac files (3rd party) -> troubles
using wince 5 (pb5)
the hive based registry (storage card) works fine
i have a .gac file for custom.dll (\Windows\custom.dll)
and a .dat file which copies the custom.dll from \Storage Card\ to \Windows
if i do a fresh restart of the system without folder 'Documents and
Settings' for the registry hive everything wors fine:
- i get the GAC_custom_v1_0_0_0_cneutral_1.dll in the \Windows folder
- the custom.dll gets deleted from \Windows folder
after a restart the registry hive already exists and gets merged during boot
also the registry keys for my 3rd party assembly are n...Terminal Server based Outlook 2007 printing hieroglyphics
We are running terminal services(Server 2008 R2) with Outlook 2007 installed
(SP2). No other Office components are installed.
When printing emails, (all other printing is fine), the text becomes
compressed and looks like hieroglyphics.
1. I have tried removing all printer drivers and re-installing the drivers
with no luck.
2. I have also applied the lastest patches and Service packs to the server
3. I have tried using different types of drivers with each printer ie. PS,
MS, PCL5e, PCL6 etc with no luck.
Any help would be appreciated as users are getting very fr..."Free Stock Trading Resources for you" "Knowledge is wealth" is the oft repeated, but absolute truth. And to add on to your knowledge arsenal, here are a few Excellent and Educative resources absolu
"Free Stock Trading Resources for you" "Knowledge is wealth" is the
oft repeated, but absolute truth. And to add on to your knowledge
arsenal, here are a few Excellent and Educative resources absolutely
Free..The aim is to ensure that you Succeed on the Financial front.
Check these out... May be it could mark the difference between Failure
Elliott Wave Video Crash Course
Ok, firstly, sorry for the very general question!
Basically, I have coded a program using MFC. It is Dialog Based and consists
of some textfields and a few buttons. My program is called DCP and the App
Wizard created a DCP.cpp and DCPDlg.cpp files for me (and a few others).
The bulk of the functionality of my program is written in the DCPDlg.cpp
file - is this correct? For example, when I created a button and clicked on
it in the resource (dialog) view it automatically puts a function for it in
the DCPDlg.cpp file i.e.
// Do some stuff here
I have ne...smtp connector based on sender?
Is there a way to create an smtp connector based on the sender's address
space rather than the recipient's?
For example, I want some of my users to have their e-mail sent through
smtp.foo.com and I want other users to have their e-mail sent through
Would appreciate any help. Thanks!
I just realized this post isn't very clear. I should clarify and mention
that I'm not looking for a connector that does anything with inbound mail.
In fact, I want the "equivalent" of a connector for outbound mail. In other
words, I want to be able to route outbou...Knowledge Base
Is it just me or have these microsoft morons gone and turned off the use ful
part of the knowledge base like being able to select a product and getting
abck sensible in context results? All of a sudden I get thrown into a generic
search web form.
First off, your asking for help regarding the Microsoft Knowledge Base on a
Microsoft Forum and you call them morons. Definitely not the path I would
have chosen to ask for help!
That said, yes they have changes their website. You can however select your
product first and then run your query. On the main page simply press the
select a prod...age-based life insurance
There's not way for the GP HR Life Insurance Setup window to calculate
age-based insurance as of January 1 instead of by a person's age, is there?
I would like to know this too.
> There's not way for the GP HR Life Insurance Setup window to calculate
> age-based insurance as of January 1 instead of by a person's age, is there?
...Formulas to reference range based on data in column
I probably didn't title this too well.
I have a spreadsheet with 500 rows of data, sorted by the date in column A.
I want to extract certain data from rows that all start with the same
Previously I used an IF formula but that necessitates having the formula in
500 rows which won't work for my purposes.
I'm going round incircles trying to think how best to achieve this.
If you apply a filter to the date column for the selected date you can
then just highlight the visible rows and copy/paste or cut/paste them
elsewhere (eg another sheet) to extract ...How to add attachments into the Knowledge Base?
How to add attachments into the Knowledge Base?
I heard that its possible with some code.
Is there anyone outthere with a small handy guide for that :-)
or even a ready to use codesnippet?
I don't think it's possible, what our clients does is linked to an
external resource like sharepoint for their attachements. If someone
can figure out how to attach to a knowledge base, please share, I
would like to know.
Crowe Chizek and Company
On Jul 17, 12:30 am, A.K.V. <A...@discussions.microsoft.com> wrote:
> ...Pc Based Home Theater
Monster MCC AV100 Activity-based A/V Home Theater Controller
Best deal: http://bestdealfinder.us/index.php?id=B000CQPFCU
...formula based on format
Is there a way to have a formula that is based on a cell colour or based on
the way a cell is formated? I need it to count the number of occurrences
that this happens.
Thank you for your time.
you'll need VBA. See for an example:
"James Kendall" wrote:
> Is there a way to have a formula that is based on a cell colour or based on
> the way a cell is formated? I need it to count the number of occurrences
> that this happens.
> Thank you for your time.
> Windows NT
> Office 97
This ...How do I count based on two conditions?
Hi there. I have a long lists of data to sort though and I am trying to write
a formula that counts that number of entries for a company with a certain
condition entered in another column. For instance
Company name Condition
Big Corp operatonal
Small corp operational
Big Corp non-operational
How do I count where Big Corp is operational and where it is non-operational?
Try this, Mark:
Hope it helps!
"...Filter based on formatting
In an Autofilter, is it possible to select the cells which have a specific
background color (say, yellow)?
Please reply to newsgroup, not e-mail
Not without some VBA Function help.
See Chip Pearson's pages on colors.
Using a helper column and Chip's CellColorIndex Function you could then
Autofilter on Color Index number returned by a formula in the helper column.
Gord Dibben Excel MVP
On Tue, 2 Mar 2004 18:55:39 -0600, "Fred Smith" <email@example.com> wrote:
>In an Autofilter, is it possi...post card mail merge from excel data base
2 post card files, 1st file is info for front of card, 2nd post card file has
return address and is used with mail merge. Can print either file and the
printer prints on every page. With mail merge selected printer prints on one
page, skips a page and prints on the 3rd page. I assume that it is printing
the blank first page of the 2nd file.
Why, How do I get arround this?
Printer is Dell 1600n w/ no duplexing option.