|
|
Conditional format if cell contains formula by
Jean-Marc[_2_]
Is there a way (conditional formatting?) to apply a different format to cells
that contain a formula, as opposed to cells that have a directly entered
value?
( 1 2)
|
|
13 |
502 |
|
|
formatting cells by
pat67
Hi, I am trying to format cells that contain dollars in millions and
make it decimal. i.e $1,500,000 would show $1.5 and the head of the
table would say...
|
|
1 |
177 |
|
|
vlookup(date, range,3) by
David
Hello Group,
I am doing a vlookup on a date, I will take the closest date, so have not
used the last parameter. It returns the last date in the list always....
|
|
3 |
226 |
|
|
Excel 2007 - worksheets macro by
version83
Hello.
I am using excel 2007, and i am still a beginner, so i would like to
ask for your help for making the following:
a macro which adds a list with the...
|
|
1 |
212 |
|
|
Using spreadsheet to fill in forms by
Nicci
We need to create a form of an invoice in a very specific format (determined
by an international shipping company). We will have several items which will...
|
March 16th, 2010 08:48 PM
by Eva
|
2 |
197 |
|
|
Vlookup and Hlookup by
cadustin
I am trying to figure out something that may be very simple, but I am not
getting it. I want Vlookup to look at two things to bring back an answer.
Here is...
|
|
4 |
226 |
|
|
|
|
1 |
212 |
|
|
|
March 16th, 2010 08:06 PM
by JLatham
|
1 |
191 |
|
|
sorting grouped cells by
D$
Is it possible to sort grouped cells? I have a sheet designed for volleyball
stats where total stats show when all the individual game cells are
collapsed,...
|
|
1 |
211 |
|
|
Excel Sorting by
Lori
I did not create the worksheet, but need to sort the data. Get a message
saying " This operation requires the merged cells to be identically sized"
An...
|
|
2 |
167 |
|
|
Looking for a Function? similar to LEFT by
KatieR
I have a list of org unit names that are always preceded by a 3 digit number.
How can I just show the text and not the numbers?
Example: 001 Org Unit Name...
|
|
5 |
176 |
|
|
|
March 16th, 2010 05:26 PM
by rzink
|
3 |
223 |
|
|
|
|
0 |
153 |
|
|
If function and a range by
mrsatroy
I have the following function and it is only half working for me as my
arguements seem to contradict one another as I want to see if my number falls
within a...
|
|
4 |
189 |
|
|
hiding/unhiding rows by
Art
I know I can create a macro that allows a user to, say, press CTRL-H and the
first three rows of my spreadsheet will become hidden. (Some users prefer
having...
|
March 16th, 2010 05:00 PM
by Paul C
|
1 |
188 |
|
|
Creating a Macro to autofill and save by
LauraB
Hi,
I am trying to create a macro that will complete the following.
Autofill column K with sequential numbers starting from cell K2 with 1 to
however many...
|
|
9 |
228 |
|
|
|
|
2 |
165 |
|
|
|
|
3 |
201 |
|
|
If Vlookup is error ( #NA) by
Steve
I have this formula
=IF(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)0,(VLOOKUP(RU!C3,data!$E$3:$R$16,2,FALSE)),"")
that is producing #NA if it doesn't find C3. I...
|
|
5 |
240 |
|
|
Setting up a formula (when F211,000)=$25 by
Hawkeye
Setting up formulas for my business on Excel 2007. I have a column for lot
sizes of properties. I need to have a second column that contains a formula
that...
|
|
3 |
140 |