Conditional Formatting #33
I have a very large spreadsheet where I would like to use conditional formatting...I have the columns set up with times as follows
Arrival Time Triage Time Registration Time To ED Time DC Tim
Numerous people input the times and they are not always correct (people are DC before they arrive, etc.) There are about 3,000 lines for one months worth of data.
Is there a way I can put Conditional Formatting so that if Triage Time is Less than Arrival Time then it can highlight a cell?
This worked!!! This is going to save me hours of time each month. Thank you!!!
...Incorrect Date Format
Hello to all,
1. Excel 97 SR-2 and Windows 98SE, Short Date Format dd/MM/yyyy
I wrote a macro that imports dates (dd/mm/yyyy) and stock prices from an
Access database, then adds some formulas at the bottom of the data to
calculate highest and lowest prices and the corresponding dates.
Works fine, and the formulas correctly return the price and date (in
dd/MM/yyyy format, without needing to format the cells).
2. Excel 97 SR-2 and Windows XP Pro SP1, Short Date Format dd/MM/yyyy
The macro created in 1. above works fine under these conditions, but the
formulas that return the...Printing Barcode Font in RS2008
We have several reports that use custom barcode fonts, and these have been
working happily for ages.
We have recently deployed our reports to a sql2008 instance and have hit a
The Report Previews correctly in Reporting services (i.e. the user sees the
The report previews AND prints correctly in VS2008.
When we print from Reporting services the barcodes font is not displayed
(gibbersish characters are displayed instead).
We have checked that the users all have the barcode fonts installed locally.
We have also installed the barcode fonts on t...caption font
I would like to know if it is possible to change by program the font
used in caption bar, menu, status bar, ...
Raymond Mercier wrote:
> I would like to know if it is possible to change by program the font
> used in caption bar, menu, status bar, ...
> Thank you
> Raymond Mercier
The status bar is a control, and like other controls its font can be
changed by calling its SetFont function with a CFont that you initialize.
But the caption bar and menus are drawn by Windows using the system
preferences. You cannot direct...Conditional formating of cells
I have an array of numbers in excel. I want then to display as percentage
if I've selected "proportional" from a drop down menu. I want them to
display as a number (0.00 for example) if I select "absolute" these are the
only two options in the menu.
I'ved tried using the Format code help in Excel but I can't manuipulat it to
get it to work how I want.
Any help will be greatly apprecaited.
Let's put the drop down in column A and the data to be formatted in column B.
Enter the following in the w...How to write in Japenese font?
I want to write in Japenese font in Word. Is there any possibility to write
in MS Office 2003 with On-screen keyboard?
It's not a Word thing, it's a Windows thing.
Go to Start > Control Panel > Regional and Language Options, and try
to follow the tabs and buttons for "installing a new keyboard" (not
"installing a new language") They are rather different in XP, Vista,
In XP you need to check the box for "Asian scripts" (not "complex
There are many different input methods for Japanese; you can read
...FORMAT CELLS #10
I have a worksheet. Within that worksheet I have a few
cells which if I right click on gives me the menu options
and when I select the format cells nothing happens. While
it opens a dialog box for other cells.
I wanted to protect some cells by selecting the format
cells options. Can someone tell me what is happening and
why nothing happens if I select the format cell option ?
The only time I've seen this is when the original workbook was created in a
different program--crystal reports or Lotus 123.
I included a few "sacrificial" cells in my selection, made my...Calendar coloring
In a class this morning (entirely different subject) a student asked about
coloring appointments in Outlook 2003's calendar. I had never heard of it ,
so when I returned home this is what Help provided.
"Microsoft Outlook has 10 colors that you can use to color appointments and
meetings. These colors are visible in Day/Week/Month view of Calendar. You
can color individual or recurring appointments and meetings manually, or you
can use rules to automatically color items that meet certain conditions,
such as when a certain word is used in the subject or when a meeting request
We are using Outlook 2000 and need to disable the font
selection for signature blocks (we want to keep it at
Times New Roman 10). Is this possible?
Again thank you in advance for your help.
...Is there font size limitation on antialiasing?
I made a program to display a character on LCD.
To apply anti-aliasing, I created font with ANTIALIASED_QUALITY flag.
[ CFont.CreateFont(... , lfQuality, ...) ]
The problem is like this:
When I displayed characters that the font size is larger
than about 680-pixel, the anti-alising is not applied on displayed character.
So I tested my program on the other computer. (My computer is Win2k, the
other is WinXP.)
At this time, characters that the font size is larger than 330-pixel is
with no anti-aliasing.
[ ANTIALIASED_QUALITY ] Windows NT 4.0 and later: Font is ant...font size in comments
Excel 2003 all sp and patches loaded
OS: Windows XP
Can you change the default font size in comments?
From Debra Dalgleish..............
You can change the font size of new comments by changing the settings in your
(Instructions for Windows XP)
Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
(Note: selecting a font type here will not affect the default font used in
Gord Dibben MS Excel MVP
On Tue, 9 Jan...color is wrong on inserted picture or appears as red X
The color in a few of my inserted photos appear & print
wrong and one of them just shows up as a red X. When I
insert the photo, the image preview also displays it in
this incorrect manner. However, when I look at the file
outside of MS Publisher, the image is fine. What's going
View, picture (pictures) display, tick detailed display. What version Publisher are
When you go to print there are options about not printing graphics, where this is
found depends on your version of Publisher. In 2002 on the main page click the
advanced button, graphics and fonts tab, un...I can't add 256 color Bitmap! to my Visual C++ Application.
I can't add 256 color Bitmap! to my Visual C++ Application
You can use LoadImage to load it.
Ajay Kalra [MVP - VC++]
"David" <email@example.com> wrote in message
> Hi folks,
> I can't add 256 color Bitmap! to my Visual C++ Application.
...how to change default comment format in excel (2000)
I want to change the default font for comments. I know how to do this each
individual time but want to make the change permanent so I don't have to do
it each time I enter a comment.
Debra Dalgleish has some notes how to change the Font size at:
And she has a macro that can do more:
> I want to change the default font for comments. I know how to do this each
> individual time but want to make the change permanent so I don't have to do
>...Default Fonts and Font Colors
Can anyone tell me how to reset the default font type and color?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from glomax <firstname.lastname@example.org>...
> Can anyone tell me how to reset the default font type and color?
Can anyone tell me what version of Publisher you are running?
Ed Bennett - MVP Microsoft Publisher
Before reading this message, view the disclaimer:
You cannot, you need to upgrade to Publisher 97 for all those excellent
Publisher 2003 has re-introduced some of...Cannot see installed fonts in programs after installing with Font
OS 10.4 with current updates. Installed a TTF using the Font Book and it
shows there correctly. But when going into Word for example, type in text,
highlight it, click on the font format and the new font that was installed
will not show in the list. I have already tried deleting the font cache,
then rebooting and reinstalling the font thru the Font Book and just manually
copying to the /Library/Fonts folder.
Althought it sounds like you may already be aware of what it refers to,
below is an excerpt from;
My fonts are become unstable in Publisher. I believe manly those that I
downloaded from the internet. Sometimes I’m not able to use them at all even
though, they are still appearing installed. Or I just able to change part of
the text and if I add more to it the whole text changes back to the previous
In Word I do not have any problems with my downloaded fonts.
Any idea what’s happening and what could be the solution?
I appreciate your help.
Using: MW 2003, Excell 2003, PowerPoint, Publisher 2003, FP 2003,
There are some fonts that you can download that do not in...Excel cond. formatting
I'm looking to format a series of cells conditionally, ie
if cell H7 reads "YES" then I want cells H1->H6 to all go
green. Conditional formatting will allow me to do one
cell, I know, but how do I extend this?
I need this to happen automatically, not thru Macro's if
at all possible.
for each of H1:H6 (can be done in one selection).
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"geordiebri" <email@example.com> w...How Do I Trim and Format This Text?
I have a series of cells that contains text in the format:
Is there some way to remove the beginning/ending asterisks and the
exclamation points so that the cells always display as follows:
My Whole Name
Any help would be greatly appreciated!
Select the range of cells in question.
Find What: ~*
Replace With: nothing, leave this blank
Find What: !
Replace With: enter a space by hitting the spacebar
>the cells always display as follows
If that data is imported/copied from another source th...How do I change the color of the font shadow in Publisher2003
I want to put a mail merge field in a publisher document and highlight it
with a shadow colour other than grey.
Chris <Chris@discussions.microsoft.com> was very recently heard to
> I want to put a mail merge field in a publisher document and
> highlight it with a shadow colour other than grey.
Create a second text box with the merge field in, displace it slightly, send
it behind the first text box and change the font colour.
Ed Bennett - MVP Microsoft Publisher
...Font problem with metafile
I have the following code to draw vertical text to a DC.
lf.lfEscapement = 900;
lf.lfOrientation = 900;
CFont* pOldFont = pDC->SelectObject(&font);
it draws correctly on the screen but not to a metafile.
When I insert the metafile to Word the text is not
vertical. But on the save machine when I insert it to
Excel the text is vertical.
What could be the problem. Can anybody help me.
If the metafile looks like expected in Excel, but not in Word, I would
normally say that this seems to...Fonts in Contacts
This is a multi-part message in MIME format.
How do you change the DEFAULT font in Contacts?
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; =
<META con...Formatting text in a cell
Is there a way to key text in one cell that is multiple lines? We would like
to be able to insert new lines where we want them.
Thanks for the help!!
Use the Formula Bar:
1. click in the formula bar
2. in the formula bar, move the cursor to the desired point of insertion
3. touch ALT-ENTER
4. enter the new line.
Gary''s Student - gsnu200855
> Is there a way to key text in one cell that is multiple lines? We would like
> to be able to insert new lines where we want them.
> Thanks for the help!!
> ak...Andy Font & Universal Font ...
I was able to download the Andy font recently, but had to
reformat my HD. I believe it came with a Microsoft
Publisher update, so I wasn't too worried. However, I
cannot seem to locate the font again. I also understand
the readers on this Newsgroup are incredibly intelligent
and know everything in the world. Any clues on how I can
get that font back. Also, since I'm on the topic, I could
also use the Universal font. Thanks, buds.
Don't think this font ever came with Publisher.
Mary Sauer MS MVP
http://www.mvps...Radar Chart with Multiple scales
I'm trying to create a Radar/Spider Diagram that will allow me to show
multiple scales. For instance, a few of my numbers are in %s while others are
in Dollars. I have 10 categories I'm showing. Each time I try to change the
"selected" scale, it changes it for each point. How can I have multiple
Custom Radar Chart
I also have a functional add-in based on the idea. I will try and
upload it to my web site in the next few days...but no promises.