|
|
conditional formatting with time values by
Access Idiot
Hi, thanks for any help with this if you can.
I have a spreadsheet where I have calculated the time it takes to make a
trip accordong to our report, and one...
|
|
2 |
203 |
|
|
I need to round up to the nearest 50. by
karenm
I am trying to calculate the number of raw material bags I need in a batch.
If I use the mround function is will round down. Is there a way to only
round up?
|
September 13th, 2005 03:31 PM
by KL
|
3 |
70 |
|
|
|
|
3 |
99 |
|
|
copy and paste only unhidden information by
heatherB
i have an excel doc. that has hdden and unhidden information. i want to
copy and paste ONLY the unhidden information. When i copy and paste it it
takes...
|
September 13th, 2005 03:34 PM
by Ray A
|
2 |
88 |
|
|
|
|
1 |
90 |
|
|
Renaming Cells linked to Pivot Tables by
gsimmons2005
Hey guys,
Is there a way to rename the field heading that are linked to the
pivot tables, so when I click update data, it just takes on the new
name.
Right...
|
|
2 |
130 |
|
|
|
|
2 |
95 |
|
|
|
|
2 |
160 |
|
|
Pattern Formula? by
sixwest
I'm OK with understanding conditional formatting but my question is for
adjacent cells. What I need to do is to enter a conditional value in one cell
(in my...
|
September 13th, 2005 04:20 PM
by Ian
|
3 |
81 |
|
|
formula by
martin
i have a list of postcodes that i need to be able to pre select the zone ie
1-10
example
AB = 1
PE = 3
|
September 13th, 2005 04:24 PM
by martin
|
4 |
119 |
|
|
|
September 13th, 2005 04:29 PM
by Ray A
|
2 |
73 |
|
|
Percentages by
quiddity
I need to set up a sheet whose columns will show red when cells between
.005 and 6.99, green when =7 and white when 0. I used conditional
formatting to...
|
September 13th, 2005 05:03 PM
by swatsp0p
|
1 |
61 |
|
|
setting of screen zoom in excel by
Sunantoro
I need to have the Pre Set Zoom sizes of 85% and 65% in replacement of the
75% and 50% Excel Zoom Out Defaults.
Is it Possible? Thanks
SUNAN
|
|
1 |
114 |
|
|
Pivot Table Lookup Grid by
MIVELD
Hi
I am looking for a way to lookup a particular cell within a pivot
table
the pivot table contains 8000 account numbers down the left hand side
and the...
|
|
1 |
84 |
|
|
|
|
2 |
70 |
|
|
counting problem by
LucasBuck
How could I make a function that would look at two columns of data, and
count how many have a value of zero in both cells of a row? ie
1 2
3 5
0 0
2 ...
|
|
4 |
86 |
|
|
Excel 2003 Auto Save by
manders
Why have microsoft got rid of the very useful autosave function on Excel 2003?
|
|
3 |
149 |
|
|
|
|
3 |
100 |
|
|
How to add right-click menu in excel. by
oioioi
I have a user who cannot right click on cells.
When she right clicks on a cell nothing happens.
I have check in MS-Word (thinking that it has something to do...
|
September 13th, 2005 05:45 PM
by Mike
|
3 |
93 |
|
|
|
September 13th, 2005 05:46 PM
by Mike
|
1 |
108 |