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...can i match a colour to its wavelength in nm
I have no clue what nm means?
Mary Sauer MSFT MVP
"aquakem" <firstname.lastname@example.org> wrote in message
Mary Sauer <email@example.com> 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....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
...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...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,
...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
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...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...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" <email@example.com>
>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.
&...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...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...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...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
...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" <firstname.lastname@example.org> 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
...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...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,...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 email@example.com> wrote in
> The fill colour icon is not allowing me to insert or remove colours
...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, ...Count by Colour (Text) with other criteria
I have a range of data in cells G4:O181
I have used =COUNTIF($G$4:$O$181,"Debs") to count the number of
occurences of Debs
In some of the cells Debs is black text and some Debs is red text
=(PERSONAL.XLS!CountByColor(G4:O181,3,TRUE)) will give me the total
number of cells that have Red Text
I have tried this formula to calculate the number of cells that are
both Debs and red text
enterred as an array, but get the value zero
How can I combine the two to get the result for the number of cells in
the ra...Tracking changes
I am using Word 2007, my track changes are set to change by "Author". When I
track changes in a document they appear in red, no-one else makes any edits
to my document, but when I open the document the next day, my changes appear
in blue - they seem to change colour each day. Does anyone have any idea why
this happens or how to stop this? I need to keep the changes set by "Author"
as I also work with others on some documents + this is our system setting.
When the colors are assigned "By author" you make sure that differe...Colour by clicking cell
I am searching for a way to change background colour by click in a cell and
back to normal colour by clicking it again.
Is this possible? And if how is it don?
Thank you in advance.
How about double-click?
This is a demo for cell B2:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
If Intersect(Target, Range("B2")) Is Nothing Then
If Target.Interior.ColorIndex = 6 Then
Target.Interior.ColorIndex = xlNone
Target.Interior.ColorIndex = 6
Cancel = True
This goes in worksheet code, not a standard module.
...how do i get a line drawing from a colour photo?
Since installing vista i cant run MS Picture it, a program that was useful to
me cos of the effects I could achieve ie pastel, water colour, oils etc. Does
MS publisher have the same facilities? Chiefly can I produce a black line
drawing from a colour photo? Alternatively is there some way I can install MS
Picture it with a bridging tool? or is there a new version of Picture it or
silimar I could buy?
No, Picture It was a completely different program and is no longer produced.
I really like Adobe Photshop Elements. (They might even have a free trial.)
It will do what you a...