How to make a cell equal another cells colour?
I have conditional formatting on a set of values to highlight high/low values
using a 2-colour scale.
Is there a way I can get another set of cells to mirror the colour alone
without changing their values?
Many thanks in advance
Have them use the same conditional format rules, simply references the cells
they are "mirroring".
"Sam.D" <SamD@discussions.microsoft.com> wrote in message
>I have conditional formatting on a set of values to highlight high...Recover a Prod content database to Dev farm
I was wondering is it possible to recover (copy) a content database from a
seperate farm to a Dev farm? I came across a few hints about using the "Copy
the database files to a network folder" option, but nothing concrete. I'd
appreciate if someone could clarify this for me?
You can recovery a database to a network location. We have the following
You will see the details in the "Tasks" section
Santhosh Sivarajan | MCTS, MCSE (W2K3/W2K/NT4), MCSA (W2K3/W2K...Excel does not return to previous cell
I am running into an problem with my users. We have a Excel 2000
spreadsheet. I know that typically, the sheet/cell that is selected
when a user closes the spreadsheet will be the same when a user opens
the spreadsheet the next time. However, the problem I am seeing is
that the proves true with some users, but not with all users. Some
users open the spreadsheet and instead of going back to, say cell A972,
it opens to, say cell B4.
I would welcome any input on this issue.
<<<"I know that typically, the sheet/cell that is selected when a user...Entourage not Downloading Whole messages/displaying HTML
Operating System: Mac OS X 10.4 (Tiger)
Email Client: pop
Sorry for what is really a simple question. <br>
last month had to "rebuild" database. <br>
Since then, emails do not download in their entirety nor display HTML. <br>
I have changed the preference radio button to Display HTML repeatedly. <br>
I have un-checked the partial download messages radio buttons on the account setting repeatedly. <br><br>Please help...DRIVING me NUTS to have to click download whole message on virtually EVERY message. <br><br&g...Listbox contents do not show..
Hi (Access 2003..),
I have an unbound listbox I use to get some info from a user (by merely
selecting a row). The listbox, and its contents show properly.
There's an "after update" event for this box where I gather and analysze
some info, such as the row number and the content of various columns.
So far so good.
I've recently added some code that sometimes issues a warning message (based
on circumstances). This is done as a msgbox with some verbage and which
simply contains an OK button.
The problem is that when the msgbox appears on the screen, the entire
content...Cell Shading Color
I am running Excel 2003 in Win XP Pro SP2
I would like to set up cells so the fill color:
= pale blue when the entered value is => 110
= no fill if =< 109
Is this possible? if so, how do I do it?
Conditional formatting. Format>Conditional Formatting and set the tests
(remove nothere from the email address if mailing direct)
"Bill" <firstname.lastname@example.org> wrote in message
> I am running Excel 2003 in Win XP Pro SP2
> I would like to set up cells so the fill color:
>...19 Digits in a Cell
It has been necessary to put 19 digits in a cell but the last four
revert to Zeros (0000) I have attempted various formats of the cell but
of no availe, Why? and Help please.
bri's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27704
View this thread: http://www.excelforum.com/showthread.php?threadid=489539
Preformat the cell as text (format|cells|number tab|Text)
Or start your entry with an apostrophe:
> It has been...click on cell takes you to specific sheet
Sheet 1 is a summary. Each value comes from an underlying sheet.
Is there a way of clicking on the cell and it will jump me to the specific
sheet. With 40 or so sheets it is hard to remember which sheet generates the
value on sheet 1.
You can make a hyperlink which lets you jump to a specified cell in a
specified worksheet with Insert / Hyperlink.. /Place in This Document .
"Ron Tarr" wrote:
> Sheet 1 is a summary. Each value comes from an underlying sheet.
> Is there a way of clicking on the cell and it will jump me to the specific
> sheet....copy entire contents worksheet into new workbook, link but editabl
I need to copy the entire contents of a worksheet which is used by several
collegues who need to see it looking the same always (headers in the same
order,etc). In the new worksheet (workbook) I will rearrange the data for
other purposes. However, I will need the data to be kept up-to-date as per
the source worksheet.
...Protect cells from moving
I have a protected worksheet with unprotected cells for users to input
There are formulae which read the cells to build up a set of codes.
Users have been moving thier input cells (Cut & Paste) which of course
corrupts the formulae.
Protection allows me to prevent inserting and deletion of rows but not
How can I prevent users from moving cells. Its fine if they want to
copy. So Copy & Paste is fine but not Cut & Paste.
...Calling HTML Help from subform
I'm working in ACCESS 2003 on Windows XP. I converted our .hlp help file to
..chm and I am using the code from Microsoft's web page at
http://support.microsoft.com/?kbid=275117 to call it. Our .chm help file
opens fine for all forms and controls except for subforms which are contained
within main forms. Can anyone tell me how to change the code so it (the help
file) opens when the focus is on a control in a subform? When the focus is on
a control on the main form the code works but not when the focus is on the
subform. I have context IDs on all the form and subform controls. Th...Pasting into visible cells only
I have two worksheets that are set up to custom view with
a sort function; i.e. it hides lines. I know how to copy
visible lines to a fully open worksheet. If the worksheet
I want to copy to is also sorted to have the same number
of visible lines is there a way to copy just into those
visible lines? I get an error box saying " cannot paste in
to multiple selections".
Excel will only paste into a contiguous range, so you can't copy visible
cells only, and paste into visible cells only.
TV Man wrote:
> I have two worksheets that are set up to custom view with
> a so...Creating column content based on another column's keyword(s)
I'm trying to create a -new- *Category* column based on keywords from
pre-existing *Names* column.
For example, if the *Names* column is full of US maps (e.g. Abielene
TX; Akron, OH; etc.), the *Category* column's adjacent cell woul
contain just the state:
A2: Abielene, TX | B2: TX
A3: Akron, OH | B3: OH
At its simplest, the *Category* column could just be the firs
letter/number/charc of *Names* column.
Basically, I'm looking for the proverbial quick n' dirty macro scrip
to achieve these results.
--------------------------------------...Internet Explorer cannot display this feed
The feeds section works for about a day before reverting to 'Internet
Explorer cannot display this feed' . After removing allthe feeds and starting
over for the 7th or 8th time I guess it is time to give up. This is not the
only problem in IE8. Stopped using IE 8 years ago but thought it was worth a
try with a new computer and Windows 7. BIG BIG mistake. There is obviously no
answer to the problem as nobody gets a response from MS. Typical.
"craggers" <email@example.com> wrote in message
news:065995F7-7510-4341-B43E-39AC774FB8A0@microso...Displaying a blank cell
I have this formula in my spreadsheet...
=IF('Prospect Questions'!B61=""," ","")
Obviously, if cell B61 on the Prospect Questions work sheet is blank, I want
this new cell to appear with a blank. Otherwise I want the contents of what's
When I enter this formula, it is displaying the formula.
What am I doing wrong??? Is the formatting wrong??? Or just the formula??
Have you text format in the cell with the formula? Also,
=IF('Prospect Questions'!B61="","",'Prospect Questions'!B61)
I noticed th...keyboard shortcut to return to previous cell after "find" or "got.
Is there any easy way to returnt to the previously selected cells? This is
helpful especially after "goto" or "find".
One way is to have 2 macros, both with their own shortcuts, one to store the
current active cell address, and the other to use that stored address to
reset the active cell. The macro would store the address somewhere on the
sheet, or in a Public statement.
Or a single macro could be used, which toggles between storing and
restoring, depending on the state of the storage address.
Would this be of help?
Regards - Dave.
&g...Display Report Options in Alphabetical Order/Rename Report Options
Display Report Options in Alphabetical Order in the Report Options Window
For example, when the Trial Balance Report Options window is open, the drop
down list of report options appear to be in the order in which the reports
were created, making it difficult to navigate to find the desired report
option, especially when many options have been created.
Would also like the ability to rename a report option.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
A...preventing a cell from being referenced?
How do you do this?
I don't think you can stop it.
> How do you do this?
...can I import excel cells into word as labels
I am using Office 2000, and I'm trying to import excel data into word as
labels. I have one column of numbers(approx. 350 cells) I would like to
import into Word as individual labels. can this be done?
Trial and Error takes too long!
Use Mail merge. :)
"wichita6" <firstname.lastname@example.org> wrote in message
>I am using Office 2000, and I'm trying to import excel data into ...Formula Help 03-01-10
I need to find how many times Dan occurs in a certain month. Example Below.
1 1/2/10 Dan
2 1/5/10 Dan
3 1/10/10 Perry
4 2/3/10 Perry
5 2/7/10 Dan
6 2/12/10 Perry
Answer = 2 for January & 1 for February
PIVOT table is the right tool for this.
> I need to find how many times Dan occurs in a certain month. Example Below.
> A ...Help ! Import Items from Excel or Comma Delimited file
Current user of Quicksell 2000 planning on upgrading. I have never used
Quicksell to the fullest extent possible but am planning on using RMS to the
maximum extent possible. Local partner familiar to RMS but I from reading it
seems you might have so more information to help me and him.
When I spoke with the local partner he said it wasn't possible to import
price updates yearly from suppliers. I have multiple suppliers for one
product I will probably use the UPC for the item number. He said I could
import once but would have to manually update the prices each year from the
sup...Blanking cells with formula errors
The cell with the below formula returns the #N/A sign.
The value I am looking up (A3 on this occasion) is
sometimes #N/A (which I know)
Is there an IF formula that I can incoroporate within the
above formula to return "" if my lookup value (A3) equals
I hope someone follows this!
Thanks in advance!
"Richard Layzell" <email@example.com> wrote in message
news:099101c3a7...Referencing an excel 'cell' value on the shapesheet screen
I have a value in an excel spreadsheet, Test.xls for example at cell 'A1',
that I want to use in the PinX field of a shapesheet. How do I reference the
excel sheet in the shapesheet window? I tried to use
='Path\[Test.xls]Sheet1'!A1 to do this but it didn't work.
Thanks for all your help.
That's a cool idea and it makes perfect sense, but...
I know the ShapeSheet looks like Excel, but unfortunately, you can't do this
directly. You could write some automation code that might be able to do some
sort of linking, but this capability isn't built ...> 12 series displayed, or better way?
a user has 11 curves to dispay.
in addition, there is a series of X,Y pairs that he would
also like to display.
when the (x,y) pairs are displayed (they are actually
discrete points), the first one shows fine, but any point
added after the first, does not visibly appear on the
I tried deleting one of the 11 curves... then a second
(x,y) point would display.
It appears that the chart was only able to handle 12 sets
of data. The reason that I tried to do it with a new
series for each (x,y) pair is that the info displayed when
the cursor hovers over the data point is much more...How do I get the date to display a Julian date? (yyddd)
I am trying to get the date to show up as a Julian date, yyddd. In my form
and report I need to have both regular ddmmyyyy and yyddd fields. they are
the same day so if there is an expression that I can use to convert the first
date into the julian that would work as well.
next time try a simple search for it on this site...
this was given by Karl Dewey
Format(Date(), "yy") & Format(DatePart("y", Date()), "000")
> I am trying to get the date to show up as a Julian date, yyddd. In my form