Copying a format that has been conditionally formated
How do I cut and paste a formula picking up it's own values if the cell has
been conditionally formatted.
In example, c3 is to highligh in red/bold if it's value is lower than c29
(the value of the same info from year prior). It worked for that cell but I
want to copy the formula for the rest of the 500+ cells so that d3 also read
from d29, etc.
What, exactly, is the condition you set? I'm guessing it's something like
'formula is' =($C$3<$C$29). If you use relative cell references, =(C3<C29),
rather than the absolute references, then you should ...Dual Displays
I want to connect my Sharp Aquos flat screen TV to my computer, and see my desktop on both the TV and computer monitor.
Windows Vista Home Premium.
HP Pavilion a1610n computer.
Galaxy GeForce 8400 GS graphics card, outputs: 1-VGA, 1-DVI, and 1-SVGA. There is no HDMI port on the card.
I connected a VGA cable between the motherboard "on-board" VGA port and the TV, figuring that I could use that output to work with the TV. The computer monitor is plugged into the GeForce graphics card.
Tried the Desktop "Display Setting". It says, the number 2 monitor is "N...sync contacts/calander for 1 user between 2 servers
I have a user who has an account on two exchange 5.5 servers (two different
This user would like their contacts and calendar sync'd between the two
servers (does NOT want email sync'd).
The two servers have full IP (no firewall or nat) visibility to each other
but otherwise have nothing to do with each other.
Anyone have any ideas?
...Define name box size too small for viewing large formulas
When we create a new name using insert and define name then if the formula
is long it becomes difficult to view the whole formula. Also one is not able
to use navigation buttons left,right here as if we do that then the formula
gets modified. is there any way to see the whole formula. Like for creating
ever expanding validation list using Debra's technique one uses offset etc
but one is not able to view the whole big formula.
Please guide me.
try hitting F2 while in this text box. After this you should be able to
navigate within this box.
Frank ...Display a message box "this entry is a duplicate"
How can I display a message box on a form if the shipment number is a
duplicate? I need a message box to pop up when user attempts to tab out of
Private Sub txtShipNum_BeforeUpdate(Cancel As Integer)
If DCount("*", "MyTable", "ShipNum = '" & Me.txtShipNum & "'") > 0 Then
Msgbox Me.txtShipNum & " already exists."
Cancel = True
This assumes that your text box is named txtShipNum, that the name of the
field in table MyTable is ShipNum...Folder could not be displayed
I am running Windows XP and Outlook Express 6 just fine
then one day my husband does something to my computer and
his email account won't work. My email is working just
fine but in his he cannot open his inbox. It says folder
could not be displayed, and when you send and receive it
gives you this error message:
"An unknown error has occured.
Server:'incoming.verizon.net'.Protocol:POP3, port: 110,
Secure(SSL): No, error number: 0x800C013B"
If anyone could help me with this I would greatly
T...Outlook Name Suggestion Issue
I am working on a strange issue with name suggestion in Outlook 2k3 version.
For some users when I type the alias for the first time it resolved the name.
The next time I try to type few characters for the same user. it suggests me
with the complete name but this time in the brackets <> the alias would be
some starnge name with some numbers. This strange alias number does not
existing in our organization nor the number that appears along with it
appears in the User AD properties.
First time I type the alias as:
"nnair" and press Ctrl + K = It resolves...how to display values in 3 cells into one cell
Anyone can help me how do I display the 3 separate different values in 3
cells into just one single cell ?
thanks so much in advance.
Either there was a typo or there's an echo in here.
That line should have been:
= A1 & " " & B1 & " " & C1
"Bradley Dawson" <email@example.com> wrote in message
> In the target cell, type:
> = A1 & B1 & C1
> where A1, B1, C1 are the cell addresses that you want to concatenate.
> If these have number...How to select & display distinct values
I need help with a form please.
My form has two controls, the first being a combo box. This box should
select the company name from a lookup table. The lookup table has only two
companies in it, however, they each are repeated several time. Company 1 has
about 10 rows, company 2 has 3 rows. I used the query builder and came up
with the statement:
"SELECT DISTINCT Lktbl_Role_Master.CompanyName
When I run the statement directly from query view, it executes perfectly and
returns exactly two rows (one for each company, in a datasheet view) ho...Conditional Formatting
I need to change the fill color based on the values of other cells.
Ex. if A1 is not a null value and the cell I want to format A2 is a null
then I need A2 to have a red fill color and a certain text. If A2 isn't a
null then it should turn green. If A1 and A2 have null values then A2 should
So just to sum up
A1<>"" and A2 ="" then Make A2=Red Fill Color + text
A1<>"" and A2 <>"" then A2=Green Fill Color
A1="" and A2 ="" then A2=Yellow Fill Color
Thanks for the help all.
What version of Ex...In nameing a sheet in Excel it puts a .xls] in front why?
Every time I go to name a sheet it puts an .xls] in front of it and I do not
Did you try to put brackets around the name?
"EZE" <EZE@discussions.microsoft.com> wrote in message
> Every time I go to name a sheet it puts an .xls] in front of it and I do
> know why
Remove the bracket or other illegal character(s) from the workbook name.
In article <C9045E70-AD04-4C91-B223-8851A0DFE55D@microsoft.com>,
EZE <EZE@discussions.microsoft.com>...Display Time in Outlook
The time setting in my Outlook is one hour behind my
actual time. I cannot determine how to change the time.
Outlook is the only item that is incorrect. Other display
times in operating system are correct. Thanks, Jodi
...does anyone here actually use names?
i am self learning about excel.
i have came across NAMES topic.
does anyone here actually use names? when r they usefull? i dont reall
see a real need for them, especially in formulas.
the only time i use name is for when i name a large block of data, so
dont have to re-select the cells all the time.
Message posted from http://www.ExcelForum.com
There are lot's of uses for named range and named constants etc. See the
2 links below
Posted via: http://www.ozgrid....Money 2007 -- QIF import
After a little trial and error, I am able to import account transactions
from another system (not a bank statement, my actual register transactions)
with little trouble except for the date format.
(Before someone gets mad at me, I really don't think this has anything to do
with my regional settings!)
As recommended by an MVP from this forum, I open my CSV file with excel,
then use a converter (add-in) called XL2QIF to create a qif output file.
The actual "data" in a date field in my original csv file is "060106"
(mm/dd/yy) which is June 1, 2006,...PK and FK Displayed
I am a complete Visio newbie, and cannot find the answer I need in books or
I am trying to create ER diagrams from scratch, and not connected to real
tables, using VEA. I have added tables ('Entities') to the form, connected
them with a Relationship connector, and, in the Database Properties window
I've assigned the end points to a Primary Key on the left and a Foreign Key
on the right. But the model shows the connector as running between the top
colums on both sides, whereas I want the keys to be in that upper box and
provide the connector's end points. Wh...How to change default formatting
How can I prevent Excel guessing what it thinks I want to type in a cell
If I type in 1/2 it thinks I want 1st February 2003, but I just want "1/2"
If I type in MAR01 it thinks I want 1st March 2003 but I just want "MAR01"
Its a real pain!
I knew about that one thanks. However I want to avoid having to do that
every time. Any other ideas?
"Kevin Stecyk" <firstname.lastname@example.org> wrote in message
> Try preceding the "text" with a single ' (apost...Can you name points on a chart in excel?
Can you make points in excel show up as a certain name when you scroll over
them with the mouse arrow?
"AP" <AP@discussions.microsoft.com> schrieb im Newsbeitrag
> Can you make points in excel show up as a certain name when you
> them with the mouse arrow?
Is there any way of doing it without downloading software? I an not allowed
to do this at work.
"Frank...Clicking on Contacts folder crashes outlook
Every time I click on the contacts folder in Outlook 2002,
a window appear saying that it has encountered a problem
and has to close. It sends an error report to MSN but it
does not suggest any solution apart from upgrade to the
latest version, which I have done.
There seems to be some corruption but I cannot find a way
to resolve it - Can anyone help
...Formulas are displayed, results are not
Hello, For some reason, when I enter a formula into a cell and press
enter, the formula just stays there. Anyone know what I can do to show
I tried pressing Cntrl + `, but that didn't work.
FYI, when I cut and paste a column from a separate workbook, that
column works like normal (i.e., the formulas produce results).
Thanks for any suggestions!
Maybe your cell is preformatted as Text.
Try formatting to general then erase your =
and type it in again.
"Mike C" <email@example.com> wrote in message
news:f699bcd4-ad82-4a88-9759-5638c147b...pivot table label adding "2" to the end of a label name
I have a pivot table and sometimes it adds a "2" to the end of a row lable ie.
"joes pizza" is displayed as "joes pizza2".
the sorce data certanly doesn't include the "2" and it seems like it is
trying to tell me some thing ;). It might be hapening after i do a "replace
command" in the source data (replace "sams pizza" with joes Pizza"). any one
The only time I've seen this is when I had multiple headers with the same name.
If I were you, I'd check once more--don't forget to c...Stop displaying a line
I have a line graph/chart and it gets its values using a formula and the values of another column. However this poses a problem because if there is nothing in the targetted column the formula returns 0 cause the line to drop to the bottom, instead of casuing the line to just end until a value is added to the target column. How can I do this?
Change your formula to use NA() if the cell is empty. For example:
To hide the resulting #N/A errors on the worksheet, you can use
conditional formatting. There are instructions here:
http://www.contextures.com/xlC...Convert Lead to a Contact under Existing Account
When a Lead comes in, there are times in which the Lead is already a current
customer. There are times that this information is valuable so we would like
to create it as a Contact underneath the already existing Account.
When you go to convert the Lead, this option is not available. I don't want
to bring them in as an opportunity. What are our options? It is surprising
that this functionality is not available, but I'm getting used to it. :)
Why do you not want to use opportunities?
When you convert the lead, you have the option to create only a contact
record by sel...Outlook contact list problems
I cannot load the exchange contact list with outlook 2003. Since i have installed this version of outlook, i have a POP UP windows every time i push TO: button to get the exchange 2000 contact list from my domain
The windows says that i cannot find the LDAP server
I tried all the DC servers and i still having this problem, i cannot see the exchange contact list
dioxido <firstname.lastname@example.org> wrote:
> I cannot load the exchange contact list with outlook 2003. Since i
> have installed this version of outlook, i have a POP UP windows every
> time i push TO: ...unattached textboxes disappear when a msgbox is displayed on a tab control
I'm using Access 2003.
I have a form with a tab control on it. I was having problems with labels
flashing and I followed the suggesting from Allen Browne -
The flashing went away but now when a msgbox is displayed the unattached
textboxes that I'm using as labels disappear. They come back as soon as the
msgbox is removed from the screen.
I've searched google looking for an answer but have come up short.
Does anyone know why I'm experiencing this behavior and how to make it go
That *is* strange. Have you tr...A question about Console window(display or not display)
I've redirected the (stdin stdout stderr) of a console window process
I spawned to a pipe.
And I want to display the redirected console window, the question is:
If I display it(set Create_new_CONSOLE in createprocess and some flags
in startupinfo), I cannot use the redirected way of pipe, which means
if i do not display, i can use the pipe communicating with the child
Does it mean that as long as I disply the console window, windows will
change stdin stdout to "screen&keyboard" instead of my pipe?
That's right. If you redirect stdin or stdout then you preemp...