Message colour ?
Someone recently sent me a email that shows up red in my message window ( I
don't use the preview pane ).
I don't have any message rules that would change the colour of that message
or anything like that and the priority of the message is normal.
Anybody have any ideas as to how this is done ? OL 2002.
It's done with the default automatic formatting rules -- View | Current View
| Customize Current View | Automatic Formatting
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
...Colour Rows in Datasheet based on three criteria
I was wondering whether it would be possible to colour rows in a datasheet
(or continuous form) based on 3 criteria. Scenario is I have a series of
jobs that can be either unassigned, assigned and finally "assigned and
I would like all rows that are "unassigned" to be one colour; all assigned
jobs to be another colour and the final section to be a further different
thanking you in anticipation
On Mon, 17 Dec 2007 09:05:01 -0800, PMK <PMK@discussions.microsoft.com> wrote:
>I was wondering whether it would be possible to colour r...Colour changes
Greetings from Downunder
One of my colleagues sent me this, something of a puzzle.
She is using XP and Office 2003:-
In My Documents I have a folder of PPTs of hymns and songs that we use in
church. I file any new songs here making sure that they are a golden yellow
text on a very dark blue background. This is the way it has been for about
This morning I went to use some of them in the presentation for this coming
Sunday - and would you believe they are now ALL pale yellow on a black
background. Every last one of them - and each song is is a separate PPT
...can i match a colour to its wavelength in nm
I have no clue what nm means?
Mary Sauer MSFT MVP
"aquakem" <email@example.com> wrote in message
Mary Sauer <firstname.lastname@example.org> was very recently heard to utter:
> I have no clue what nm means?
Won't do it.
http://members.cox.net/astro7/color.html claims to have a FORTRAN program
that will do it....Why is colour printouts not same colour as in word?
When I print my logo from Word the colour is correct. When I copy it to
Publisher and print it from there the colour comes out wrong. What could be
Try importing the image rather than copy/paste.
Mary Sauer MS MVP
"DvdM" <DvdM@discussions.microsoft.com> wrote in message
> When I print my logo from Word the colour is correct. When I copy it to
> Publisher and print it from there the colour comes out wrong. What co...Mark as Unread
How do I extend the time an e-mail takes to change the
status from unread to read.
right click on the edge of the preview pane and change your preview pane
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
"Slyke" <email@example.com> wrote in message
> How do I extend the time an e-mail takes to change the
&g...Change bkgnd colour for some words in CRichEditCtrl?
I'd like to be able to change the background colour for some of the text
in a CRichEditCtrl. I'm comparing two files side-by-side in these controls
and need to be able to highlight some text to illustrate the results.
I could just change the text colour and make the font bold and/or
larger, but highlighting similar to when text is selected would stand out
better, especially if I could also change the text colour to suit.
Is this possible? (I've seen it in some programs, but don't know if a
CRichEditCtrl was used.)
Any help appreciated,
hi guys, i may be chasing the impossible here, but here we go anyway. ive got
cells in my spreadsheet formatted so that they change colour depending on
what value is input. basically, i want to know if its possible for excel to
recognise how many cells of a certain colour i have and then display the
results numerically. is this possible?
yet again, your really helping me out and it would be greatly appreciated.
If you're using Format|conditional formatting to color those cells, then I think
it would be easiest to just duplicate those rules in helper cells and then use
those helper cel...Removing Border lines and colour for All sheets
is it possible to write a macro to run every sheet and just remove
border lines and colours for all cells in a sheet for every sheets in
I know macro is like this but can't really think how I can loop this.
Can anyone help?
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
Selection.Borders(xlEdgeBottom).LineStyle = xlNone
Selection.Borde...Code to change label colour
I want a label control of a tickbox on a form to change colour if it is
checked, assuming the checked value is YES. I've tried this code but it
Private Sub txtwithdrawn_AfterUpdate()
If Me.txtwithdrawn Is Yes Then
Me.txtwithdrawn_Label.ForeColor = 255
Can anyone help me here.
Sorry for posting too swiftly, realised that checked value should be = True
and it worked.
"Tony Williams" <firstname.lastname@example.org> wrote in message
>I want a label control of a tickbox on a form t...Automatic "Mark as read" for 1 folder?
I'm using Outlook 2002 (SP-2). I also use Qurb, a whitelist, to
automatically direct spam out of my InBox and into a separate "Qurb" folder.
Is there some way I can create a rule that when a message goes into the Qurb
folder it is automatically marked as read?
"T. Wise" <email@example.com> wrote in message
> I'm using Outlook 2002 (SP-2). I also use Qurb, a whitelist, to
> automatically direct spam out of my InBox and into a separate "Qurb"
> Is there some way I can create...Automating bubble chart colours
Does anyone know if the colour of a bubble within a chart can be
conditionally formatted through reference to a cell within the spreadsheet ?
I want the colour of each bubble within the chart to based on the result of
a calculation within the spreadsheet. Currently the cells containing the
calculation are conditionally formatted to give a red, amber, green result
and I want to link the colour of the conditionally formatted cells to the
colour of the associate bubble.
(At the moment I update the bubbles manually)
The normal work around for making a charts formatting conditional is...Number colours
Is it possible to change to colour of a number to indicate whether it was
positive or negative? IE - blue for positive numbers and red for negative.
Thanks for any help.
Gord Dibben Excel MVP
On Thu, 11 Dec 2003 16:32:12 -0000, "The Stoat" <firstname.lastname@example.org>
>Is it possible to change to colour of a number to indicate whether it was
>positive or negative? IE - blue for positive numbers and red for negative.
>Thanks for any help.
&...Counting coloured cells?
I'd like to know how we can count coloured cells?
If cells A1 C1 E1 F1 and G1 are coloured, I’d like to know how I can see the
total coloured cells in H1?
I suppose it’s a little bit more complicated than it looks. Any help would
be appreciated. Thank you.
See your other post. No need to ask again.
"Atomic" <Atomic@discussions.microsoft.com> wrote in message
> I'd like to know how we can count coloured cells?
> If cells A1 C1 E1 F1 and G...Cell colours and font colours
I seem to remember that when you changed the cell to a very dark colour, the
font automatically changed from black to white. My font setting is
automatic colour but when I change the cell from no colour to black the cell
contents do not display until I go and format the font to white from
automatic. Is there something I need to set up elsewhere to make the font
change colour automatically depending on my background colour?
Thanks - Roger
you can email me at (rogero) (at) (pobox) (dot) (com)
I don't recall ever seeing this behavior.
And it's a pretty common way to &quo...Reverse colours
Re my post 'File conversion' I now find that when I try to colour text in
blue it shows up red and vice versa. I've re-installed but it's still the
Any ideas, work rounds etc?
Thanks - Dave
...Page Layout - Page Colour
How do I create a default background colour
In earlier versions this was done by Tools>Options>General and selecting the
colouyr and this remained the default colour. Am able to open a blue
background in Word 2010 but not able to make it the default colour so that it
opens in blue automatically.
Also Envelops - how can the return address be made the default address
The option that you mention was dropped in Office 2007.
If you create a template in which you set the background colour to Blue, and
save that template, documents that you create from that templ...Count coloured cells #2
Does anyone know of a way i can get Excel to count cells
that have been designated a certain colour?
Note that the colour is not dependant any any conditional
Have a look here:
"Nick" <email@example.com> wrote in message
> Does anyone know of a way i can get Excel to count cells
> that have been designated a certain colour?
> Note that the colour is not dependant any any conditional
When I am doing a Cash Flow from time to time the result in the final (Final
Balance) column is a negative one, e.g. -�500.00 To make it more noticeable
I change the colour from black to read for that one cell.
Is there a way of programming the Excel process, so that the negative
balances are always automatically shown in read? If there is could that
process be applied to other worksheets, where negative balances appear from
time to time e.g. Use of Energy? There is nothing I can see in the Index in
my book on Excel 2003.
If there is a way of programming please give me the instructions in a
...The Fill colour icon is not showing the colours
The fill colour icon is not allowing me to insert or remove colours
In Control Panel | Accessibility, make sure you haven't selected one of the
High Contrast display options.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Fill colour icon" <Fill colour firstname.lastname@example.org> wrote in
> The fill colour icon is not allowing me to insert or remove colours
...Can I Sum by Cell Colour or Format?
I have a large list of values, these values have been colour coded. I would
like to sum each of the colours seperately. I know i can add a filter, sort
by colour & sum this for each coulour, but am wondering if there is a formula
that would do this for me?
have a look here
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> I have a large list of values,...Apply Two Fill Colours Between Lines in a Chart
I am trying to produce a graph that tracks an actual performance against a
target. When the actual performance is below the target, the area between
them needs to be filled red. When the actual performance is above the
target, the area between them needs to be filled green.
I have followed the steps detailed in the TechTrax Article on "Apply Fill
Color Between Lines in a Chart"
This produced what I required except for the correct colouring.
Is this possible?
It should be possible you just n...Marking point of intersection on double y axis chart?
I have two sets of data plotted on a 2 axis line chart. The data
resembles a cross with one set increasing and the other decreasing. Is
there a simple command that will draw on marker lines showing where
they intersect, with their respective values on the axes?
TheBigLoofah's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31797
View this thread: http://www.excelforum.com/showthread.php?threadid=515232
Why don't you have your workbook do the calculation of intersection...RETAIL MARK UP FORMULA
does excel have retail mark up formula built in?
No. You just use the formula.
Selling = Cost * (1 + Markup%)
Please reply to newsgroup, not e-mail
"jimbo" <email@example.com> wrote in message
> does excel have retail mark up formula built in?
...Grouping by Colour
I've highlighted a number of rows by red, green, and blue.
Is it possible to sort the spreadsheet out by colour?, so
that all the blue Rows are at the top, followed by the Red
rows, and then the green Rows?
Try Chip's site:
"AJ" <firstname.lastname@example.org> wrote in message
> I've highlighted a number of rows by red, green, and blue.
> Is it possible to sort the spreadsheet out by colour?, so
> that all the blue Rows are at the top, ...