Color a certain range of cell if a cell contain specified word
a b c d e
f g h
if a cell contain the word "Group" + a single char, i want the row which is
the same the cell containing "Group" to be autohighted
In tis case, it will be Cell A3-H3, and Cell A9-H9 to be auto-highlight!
Put cursor on col A>format>conditional format>formula
is>=left($a4,5)="group">format as desired>copy format (use format tool) to
col e then copy format the row down/up as desired.
I have inherited a spreadsheet that has a cell that whenever you put the cell
pointer over the cell a note pops up with a description of the cell and notes
about the cell that someone apparently entered. Its not a comment and can
not be edited by comments. I have never seen this before. Does anyone know
how to edit these notes or delete these notes?
Maybe it's from Data|Validation|Input message tab
> I have inherited a spreadsheet that has a cell that whenever you put the cell
> pointer over the cell a note pops up with a description of the ...Jumping to a hidden cell on enter
I've got 3 drop down lists in which the source cells are located i
hidden rows above the data cell. Each of these 3 data cells are righ
on top of the other (of the unhidden cells) and every time I use one o
them and hit enter, rather than going to the next unhidden cell down
it goes to a hidden cell. I can see it displaying the cell destinatio
and it's contents in the input window. I try to unhide then rehide an
it's always the same cell it goes to upon enter. Does anyone have an
ideas about what is causing this glitch?
---------------------------------------------...Data validation master cell
Is it possible to change what list is in a cell by selecting the name o
that list from a "master" cell?
For instance, say the master cell is A1, and it's validation lis
contains the list "cats, dogs, horses".
The list in B1 would be based on what list is selected in A1. Fo
instance, if A1 was set to "cats", then the choices in B1 would b
something like, "Calico, Tomcat, housecat, Siamese".
What I really want to do though, is only have one "master" cell an
have dependent cells that change depending on the master.
So, if A1 is the master,...using seed cells and spinner
I am using office 2002. I am trying to use a spinner with a seed cell. The
cell that I am trying to link it to is formated with %. How do I make it so
that when you use the spinner, the %cell goes up by 1%. Ex. 1%,2%...
I'd use a second cell.
With A1 the linked cell, use =a1/100
and use that helper cell in further formulas????
> I am using office 2002. I am trying to use a spinner with a seed cell. The
> cell that I am trying to link it to is formated with %. How do I make it so
> that when you use the spinner, the %cell goes up by 1%. Ex. 1%,2%......How to Drag cell/=code so that worksheet name (e.g., 1,2,etc) increases sequentially?
Hello - I have an excel workbook within which I have named eac
worksheet numerically, i.e., 1,2,3,4,etc...
Is it possible to drag code so that the worksheet name wil
sequentially progress but that the cell will remain the same? Fo
example 1!$D$4 will upon dragging it become 2!$D$4?
Thank you in advance!
Message posted from http://www.ExcelForum.com
try the following
=INDIRECT("'Sheet" & ROW(1:1) & "'!D4")
and copy that down
> Hello - I have an excel workbook within which I have named each
I keep getting the message "To many different cell formats"
If I close Excel and restart it I can go for another 10
minutes and then the message comes up again and I cannot
format a cell.
This MSKB article helps a little.
Be advised to back up your WorkBook before attempting to make changes.
On Tue, ...Protect cells with formulas only
What is the best way to only protect cells with formulas in them?
Not sure if there is an easier way, but you can:
*Select the entire sheet (you can do this by clicking on the icon above row
1 and to the left of column A)
*Right click in the sheet and select FORMAT CELLS
*Go to the Protection tab and UNCHECK LOCKED
*Now, go back to your sheet, right click on the cell(s) you want to protect
and again select format cells
*Go to the protection tab and CHECK LOCKED
*When you are done selecting the cells to be locked go to the ribbon and
select t...Locked cells are still able to be selected with proper protection
An excel worksheet I'm developing has rows that alternates between locked and
unlocked cells. When I protect the worksheet with the option for users to
select unlocked cells and format cells checked I'm still able to select and
format locked cells by drag the cursor vertically from one unlocked cell to
another. Is there a way to prevent this from happening?
Any help would be appreciated!
Select the whole w/sheet < format < format cells < protection < uncheck then
check locked < ok
Select the areas you need to allow access
Format < format cel...Move to a specific cell on exit of current
I'd like to move to a specific cell on exit of the current cell. Can
jafo1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2459
View this thread: http://www.excelforum.com/showthread.php?threadid=38184
Private Sub Worksheet_Change(ByVal Target As Range)
Put this in the appropriate sheet module.
"jafo1" <jafo1.1r41ms_111958238...PO Receipt / Invoice Match
In what GP table is the Purchase Order Receipt Number and it's matching
Invoice Number stored?
You will need the
This should give the required information.
> In what GP table is the Purchase Order Receipt Number and it's matching
> Invoice Number stored?
...autoformat the column of a cell area
Is there any way to format one cell are so that that the width of a
cell area (something like format column width to contents) but without
formating the cells above or bellow the area I want to format
I have tried autoformat but it really does not give me what I want !
Somehow I cannot remove the autofilter that appears in the formated
Thank you, best
Personal.xls is located in the XLStart directory, and is used to store
macros and things that you want to be available to all workbooks, whenever
you start Excel.
By default, it is hidden in Excel, but if yo...Matching in VBA
Can anyone please offer some advice on where I might start to create a macro
to solve the following problem:
I have a series of xls files containing data each with a prefix of 1.1, 1.2,
1.3 etc. I want to take the data from each of these files in turn and paste
it into a master spreadsheet. In the spreadsheet there are sheets with names
that match the prefix of the downloads e.g. 1.1, 1.2, 1.3 etc.
I need to macro to match up the xls file name to the sheet name to determine
where it pastes the data.
I have code to enable it to copy and paste the data into the sh...chart moving on worksheet
I have a worksheet with data that gets updated every week and I would like
to add on top of it a chart that shows an analysis of this data as changes
are made. When I say on top I really mean it - I would like the chart to
always show on the top right-hand corner of the screen and stay there even
when the users scroll the data on the worksheet. Of course it should be
possible to move the chart if the users need to.
Is this possible at all in Excel 2003?
Many thanks in advance for your help!
...If cell contatin string like .... copy in Offset mode
Hi , and a good day everybody
Please to help me with this problem :
I have in a range (f or example : A1:E100 ),
in different cells , numbers like in the follow format /(string)
The other cell contain another values , like :
3 , - , etc .
I need a code to loop through my range cell
by cell , and , IF the value of cell is in string mode like :
17-28-34-36-39-42 ( can be different numbers , but with
the sign - beetwen them )
to copy them in another range , for example G1 ,
useing Offset function , like : Offset ( 1, 0) .
A lot of tha...Macro to copy a Cell Content automatically IF G12 cell <>""
I am having the below Macro code for moving the cursor E11,F11,E12,G11 & G12
and these cells are not protected and rest all other cells are locked (Other
than M11 cell). I got this code in google web search.
Now I want to add a small condition which is if a person enter any value in
G12 cell then the Macro should automatically do copy the M11 cell. That’s
all. M11 cell is not having any lock!
Note:- The Cursor should move in this order only that is E11,F11,E12,G11 &
G12. So please don’t change the cursor movement. The cursor should not move
to M11 cell and all...How to populate all cells of a column with the same comment?
Thanks in advance.
Copy the cell with comment
Select the target cells
Right-click > Paste special > Check "Comments" > OK
Please reply in thread
Use xdemechanik <at>yahoo<dot>com for email
"cyril" <email@example.com> wrote in message
Re: How to populate all cells of a column with the same comment?
> Thanks in advance.
�� 38 ���������
�ļ��ߣ�Ken Wright (ken.wright@NOSPAMntlwo...Add new line in a cell
I must be suffering from oldtimerers disease but I can't remember how to
to add a new line inside a cell.
I have tried various combinations of alt, shift, ctrl, enter but I can't
Did you try alt-enter?
(Remember to toggle the wraptext setting: Format|cells|alignment tab)
> I must be suffering from oldtimerers disease but I can't remember how to
> to add a new line inside a cell.
> I have tried various combinations of alt, shift, ctrl, enter but I can't
> get it.
Dave Peterson wrote:...Hide text that doesn't fit in the cell
How can I hide the part of the text that is too long for the cell? This
automaticly happens when in the cell on the right is already a text. But I
want this also when there is no text in the neighbouring cell. (Note: I don't
want to use wrap text)
see your other post
"Rene" <Rene@discussions.microsoft.com> schrieb im Newsbeitrag
> How can I hide the part of the text that is too long for the cell? This
> automaticly happens when in the cell on the right is al...Fill in blank cells with line above
I need to fill in the blank cells with the information from the cell above
until the next cell is not null. For example:
I need the blanks to read as Bill. Is there a function or something I can
Watch this short video:
Microsoft Excel MVP
"gleakos" <firstname.lastname@example.org> wrote in message
>I need to fill in the blank cells with the information from the cell above
> until the next cell is not null....when I add values in cells which have been calculated with percen.
I have set up a salary schedule to calculate employee/employer percentage
deductions, social security contributions etc. and when adding, say the
employees' contributions, the total is 1 cent too little compared to doing
a manual calculation. Obvioulsy there is a rounding issue somewhere but how
can I fix it ? Any sufggestions gratefully received !
Have a look here:
"David" <David@discussions.microsoft.com> wrote in message
>I have set up a sala...How do I anchor adjacent cells ?
Col A of spreadsheet (the recipient) contains Anchored cell refs to another
workbook (the source), and then I enter info in Col B which relates only to
the cell in Col A (eg B1 to A1 etc).
If I later insert rows within the data of the source workbook, and update
the recipient spreadsheet upon opening it, the data in Col B no longer
matches the cell in Col A. Is there any way of keeping the relationship
between the adjacent cells, ie some form of anchoring, so that this does not
1) make sure both spreadsheets are open when you change the structure of the
source wo...How do you move an inserted picture in word 07
I have inserted a pic into my document but when I try to move it it doesn't
go where I put it. It goes just above or below etc. I have turned off the
snap to grid feature but still can't move stuff to where I want. How can I
Inserted pictures are (by default) inserted in line with text, thus they
behave much as a large font character. In order to move them around you need
to select and change the wrap to something other than in line.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<...Formatting cells for worksheet data transfer
Sheet 1 contains two columns. Each column lists a hockey roster. Column A
is the "White" team. Column B is the "Dark" team. There are 22 spots
consisting of regulars and numerous substitutes. Any one player may appear
on "White or "Dark" from week to week. At the bottom of the rosters will
appear the score from a given nights game. On Sheet 2 is a list of all
players (regulars and all subs) in column A. Column B is "Wins". Column C
is "Losses". Column D is "Ties".
My question is: how do I format this s...Autofilling next empty cell in column?
Other than copying formulas manually to the next row of empty cells, can a
function within the preceding data entry cell do the work upon completion,
<enter>, or auto summing?
All cells within the range will have entries, so no isolated empty cells are
present to mess up the integrity. These are scientific, engineering functions
with no limit to range of entries.
Having searched through several manuals and this forum, I'm not too
optimistic for a solution, but keep trying...
You can create a macro that does this.
Otherwise, if you double click on th...