|
|
automatic fill color in cell by
megangiselle
I'd like to have specific cells change to a certain fill color when I type in
certain letters or numbers. Is there a way to set this up?
XP Pro
Thanks!
|
October 19th, 2004 03:40 AM
by Mark
|
3 |
168 |
|
|
|
October 19th, 2004 11:46 AM
by Paul B
|
1 |
228 |
|
|
Insert data based on match by
Deltaecho
i need to search for an occurence and when found insert a comment in the next
column. i.e.
So when EW is found in column A the letters EW will be written into...
|
October 19th, 2004 11:54 AM
by BrianB
|
1 |
159 |
|
|
|
October 19th, 2004 11:59 AM
by BrianB
|
1 |
133 |
|
|
Using two conditions in a formula by
Richard Pitt
How do I write the following formula:
I am in cell I6
If g6 AND h6 is blank, then blank, else I5 minus g6 plus h6
--
Richard...
|
|
1 |
124 |
|
|
|
|
4 |
244 |
|
|
Text and numbers by
Pepper Sue
I'm working on a job applicant scoring system. I would like for any text
that I type to represent a number value that I choose, so that I can...
|
|
2 |
135 |
|
|
"merged cells must be identical size." by
jayceejay
HELP! I have a multiple sheet workbook each with an identical table that
needs to be sorted on a specific column at the end of the month. When I
attempt the...
|
|
1 |
660 |
|
|
|
|
1 |
195 |
|
|
|
|
1 |
385 |
|
|
Comment Boxes change size & position by
bobh727
Is there a way to stop the Comment boxes in Excel from changing in size or
position? Some of the comments are squashed flat, others stretch over several
rows,...
|
October 20th, 2004 02:43 PM
by bobh727
|
2 |
300 |
|
|
|
|
2 |
173 |
|
|
|
October 20th, 2004 08:45 PM
by Gordon
|
5 |
203 |
|
|
Can't put range on chart by
Katie
Hello,
I have a spreadsheet with 50 tabs. Each tab has a 6 month audit score that
looks like this:
MAR APR MAY JUN JUL AUG
100% 100% 100% 100% ...
|
|
1 |
101 |
|
|
|
|
3 |
178 |
|
|
Background page number by
srcdc
Can anyone tell me how to finally rid my spreadsheets of that annoying
background watermark page number? It shows a big over-powering "Page
1" on the sheet. ...
|
|
2 |
148 |
|
|
File Access History by
lensolo
Is there anything in Excel that will show a history of who accessed,
modified, and/or saved an Excel workbook other than what's in the file
properties dialog...
|
|
1 |
149 |
|
|
goal seek command function by
Mark
Can you give me an example of how to input value to get a specific result for
the goal seek function;i.e, what values do we input in the boxes to get...
|
October 21st, 2004 02:09 PM
by VENKAT
|
2 |
149 |
|
|
Displaying durations in Excel by
Verbatim
I have a worksheet which calculates a duration in hours...is there a built-in
number formatter that could display that as h:mm:ss? How would I create...
|
|
2 |
182 |
|
|
Audits by
LMB
Hi Everyone,
I am using Excel 2000 and am a beginner. We are going to be doing some QI testing for our department in our hospital. We will be looking at...
|
October 21st, 2004 09:06 PM
by LMB
|
2 |
149 |