|
Conditional Formatting to Hide Rows or Columns?
I'm currently using Excel 2002 SP3. I use conditional formatting in many
of my spreadsheets, but I haven't been able to figure out how to "Hide"
a row or column based on a certain condition. Is there a method for
doing this already built into Excel's functionality, and if not, is
there a way to do it with VBA? Any help would be greatly appreciated!
Thank you.
--
sczegus...
|
4 |
27.09.2006 20:32:39 |
|
|
row of $ numbers don't crossfoot
a list of employee pay is being multiplied by the medicaid, ss and disability
rates to end with a net pay assuming no fed or state withholding. the
formula for the net is the gross less the three calculated tax results. the
result net pay is off by a penny in several cases probably due to rounding in
the formula but i can't figure out how to resolve.
--
gary e...
|
3 |
27.09.2006 20:57:01 |
|
|
conditional formatting with text
I am trying to make three conitional formats on a cell with text.
The cell text will be one of the following:
Di......
Do.....
or something else.
If the text begins with Di, I wat the cell format to be red text.
If the text begins with Do, I want the cell format to be blue text.
If the text does not begin with Di or Do, I want the cell format to be black
text.
I set the conditional for...
|
7 |
27.09.2006 20:53:02 |
|
|
Borders hidden by small blank pictures
When I open an Excel 2000 worksheet in Excel 2003, sometimes some of the
cell borders appear to be hidden. When I click one of those hidden borders,
I see six handles and a green rotate handle surrounding what appears to be
nothing. When I drag one or more of those handles, the object expands to a
large white rectangle. When I right-click on the white rectangle, one of the
options in the cont...
|
1 |
27.09.2006 20:47:35 |
|
|
Copy Tab function not working
For some reason, the copy tab function is not working for me. I can move
Tabs, but when I highlight the tab(s) and select "copy", nothing happens.
Suggestions?
Thanks!...
|
4 |
27.09.2006 20:44:07 |
|
|
Numbers act like text
We get spreadsheets from another application that have a column of "numbers"
that act like text. The only way to get them to act like numbers is to copy
them out to a text file and then copy them back in. Is there an easier way?...
|
4 |
27.09.2006 20:42:34 |
|
|
I need worksheet with a mnth worth of dts. 1 date a sheet.. HOW?
I need to make a worksheet with a month worth of dates on it... One day for
each tab...is there any easy way to do this???...
|
2 |
27.09.2006 20:39:02 |
|
|
how do you reverse the orders of numbers?
I have a list of data and i need to reverse the order of the numbers..for
example
46183
29830
50784
49774
22199
needs to be
38164
03892
48705
47794
99122
Please help.
Thank you in advance....
|
4 |
27.09.2006 20:31:01 |
|
|
Color coding cells
I need to color cells for instance if I have suppliers who are late on the
responses I need to color code a cell letting me know that the suppliers are
late and how late. Can this be accomplished and if so how?
Miller...
|
3 |
27.09.2006 20:20:01 |
|
|
when I click format cells nothing happens
I've greated a one page spreadsheet in excel. The format cells drop down
menu will not appear unless I am in an empty cell. What have I done to cause
this?
...
|
2 |
27.09.2006 20:19:01 |
|
|
Vlookup Error in Visual Basic
Hi,
I want to check to see if I get an error using VLOOKUP in visual basic.
If I do, I want something to happen; if not, skip over that step.
This is how I have it set up right now:
If IsError(Application.WorksheetFunction.VLookup(Cells(4, 5).Value,
CDSPremiumsRange, 1, False)) = True Then
....
However, when it gets to this step and it is an error, I get a runtime
error message inst...
|
2 |
27.09.2006 20:18:23 |
|
|
remove hyperlinks Excel 2003
Any help with Hypwelinks?...
|
3 |
27.09.2006 20:11:03 |
|
|
How do I insert a blank line when category changes
In Excel 2003, I have a spreadsheet with over 1500 rows that I would like to
insert a blank row everytime the category changes in one row....
|
3 |
27.09.2006 20:10:32 |
|
|
Urgently need help with a formula!!!
Hello,
I'm badly in need of some help with an excel formula. Essentially I
need to check to see if the value of C7 is "Y" and if so for the
formula then to look at D7 through to J7 and look for a value of "Yes".
the total amount of "Yes" boxes should then be multiplied by J5 and the
result shown in L7.
It is for the purpose of a timesheet, I'm trying to calculate fuel
allowances The Val...
|
3 |
27.09.2006 20:09:02 |
|
|
How can SS#s be displayed as text with all zeros and no dashes?
Hi,
I have a list of about 2,000 social security numbers in excel. Some are
formatted with an apostrophe to preserve the first zero. I need them all to
be a string of nine numbers with no dashes and to preserve the first zero in
the formula bar. The Custom formatting dispays the zero on the worksheet but
not in the formula bar. How can I format all the cells to preserve the first
zero...
|
2 |
27.09.2006 19:10:52 |
|
|
Converting ASCII Into Excel, any Ideas?
I need to convert Data from Sprint that comes in either a PDF or ASCII. I
need to convert those to and put them onto an EXCEL spreadsheet. Anybody know
how to do that?...
|
4 |
27.09.2006 18:42:01 |
|
|
Automatic updating for text boxes used on Charts
One of my supervisors has asked for me to design a new chart for an ongoing
project (that will be updated weekly), where a formula based on one only
column of data (that is linked from another spreadsheet) is reflected on a
Chart (currently) by creating text boxes and typing in the result. He would
like this to be automatically done each time the master spreadsheet is
updated.
The pr...
|
2 |
27.09.2006 18:40:44 |
|
|
Tab Function in Protected Worksheet
I'm using Office 2003 and have a worksheet protected with the ability to
enter data in a selected table. How can I get the Tab function to work in the
data entry section of the worksheet?
Thanks...
|
2 |
27.09.2006 18:37:02 |
|
|
Return Matching Data Help Needed
I am having problem getting an idea of how to do this...and problem
trying to explain it
In the worksheet there are seven columns:
Rep Store Start End Call Dur. Call Call1
In each column I have repeating data, this data is pulled thru a month
range.
I have a separate list of DM Names, these do not repeat...
What I need to do is to look for this;
If a DM and Rep were in th...
|
1 |
27.09.2006 18:25:52 |
|
|
Disable Date Recognition
How can I disable date recognition permanently, not just with 'New Web
Query', but with copy/paste from a file?
TIA...
|
1 |
27.09.2006 18:09:09 |
|
|
COMBINE COLUMNS
How do I combine two columns (of items numbers) without having any
duplications on another worksheet?...
|
7 |
27.09.2006 18:09:02 |
|
|
I can't find the Assign Macro command
I am trying to assign a Macro that I recorded to a command button. However
when I right click on the sizing bar of the command button "Assign Macro"
does not appear. Is thare another way to do this?...
|
4 |
27.09.2006 18:08:02 |
|
|
Re-sorting linked data cells
I have a table with three descriptive columns (A, B, C) and three data
columns (D, E, F) showing sales for 2005, 2006 and 2007 Forecast. Columns D-F
are linked to another worksheet in the same workbook from where they draw
their numbers.
I have created 3 macro buttons that sort the data set in descending order
according to 2005, 2006, sales, according to the user's preference. Even
t...
|
1 |
27.09.2006 18:07:01 |
|
|
Help with formula
=OR($F$1=5,$O$1=5000)The problem with this formula working is the formula in
cell F1 is being read as text (I think) and I need it to read as numerac.
Example: The cells that I need are selected and conditional formatted to
change to red if these criteria are met. If a 5 is in cell F1 or 5000 in cell
O1, The O1 cell works fine because it is a mumeric value but cell F1 has
=DATEDIF(A40,T...
|
8 |
27.09.2006 17:59:29 |
|
|
Have row color change to one of 8 different colors based on one cell's value (I, O, C, T, L, E, X, A)
Have a spreadsheet with many lines on it.
We have one cell (starting on row 2, column I) the cell will have one
of 8 different values. (I, O, C, T, L, E, X, A).
Depending on which one, would like that row to be set to change
background color depending on value in cell I2, i3, etc. as you go
down.
Base color is blank (white).
I know I cannot use conditional formatting as I have more th...
|
3 |
27.09.2006 17:47:02 |