|
|
|
|
1 |
129 |
|
|
Conditional Format Help by
Excel Help!
I'm using Excel 07; I need to set conditional format based on dates. Row "C"
projects 4yrs 6months from "B"; I need each row to change colors based on:
"C"...
|
|
2 |
142 |
|
|
converting numbers to time by
FishandChips
I have a list of numbers:
900
1030
830 etc.
I need these in the format:
09:00:00
10:30:00
|
|
4 |
150 |
|
|
Conditional Format Help by
Ayo
How do I write a conditional format that applies to
"=$N$13:$N$22,$N$31:$N$40" where If $L13$N13 fill the cell RED. This is
what I have in the Format...
|
February 18th, 2010 08:24 PM
by Amylou
|
1 |
156 |
|
|
Conditional Formating and Macros by
Les
I have a large Workbook with macors. One macro duplicates a template
worksheet with mutiple conditiional formats. The Formats in a set of cells
has 5...
|
February 18th, 2010 08:20 PM
by Les
|
0 |
111 |
|
|
Change font color if anything changes by
Vera
Hello, I'm using Excel 2003 and I have a worksheet with data in approx 1500
rows and in columns A - AN. There will be approx 8 people making updates to
this...
|
|
1 |
136 |
|
|
paste link not working by
Sam
Hi, can any one help me please, I have two workbooks that are linked using
special paste and then paste link, but for some reason just lately the links
have...
|
|
1 |
119 |
|
|
|
|
3 |
153 |
|
|
Excel formulation to automate values by
mns
Hi there,
I have a little problem on arranging a small multi-worksheet excel here.
Let me explain in a short way then give some details on it.
I am trying to...
|
February 18th, 2010 08:01 PM
by mns
|
3 |
147 |
|
|
comment format by
whiskeyromeo
How does one set the default comment format (font, etc)?
|
|
2 |
155 |
|
|
|
|
1 |
115 |
|
|
|
|
1 |
124 |
|
|
|
|
2 |
129 |
|
|
how do i show 3 significant figures by
peter
i need to show numbers to 3 significant figures. in one column, the numbers
should show as 5.36, 7.56, 20.8, 47.6, 171, 291, 1070. all to 3 significant...
|
|
1 |
125 |
|
|
Need help on formatting row height by
Bill
I have 500 rows of data. All row heights are currently at 15.
For a given column width, I need to wrap the text for about 100 rows to fit
within the column...
|
February 18th, 2010 07:45 PM
by Bill
|
2 |
132 |
|
|
|
February 18th, 2010 07:44 PM
by tompl
|
0 |
99 |
|
|
Inserting a picture XL2003 by
Steve[_75_]
If cell A1 contains a ref EG "C:\ Photos\Pic1.jpg ( this could be up to
Pic200).Is it possible to insert so that Pic1 appears in cell "f1" ?
I have...
|
|
0 |
116 |
|
|
|
February 18th, 2010 07:33 PM
by Pete_UK
|
3 |
141 |
|
|
IF/AND Array in MS Excel 2003 by
Amylou
What I am trying to do:
I have a list of 35 clients (column B), a row of 7 available catalogs (row
1: catalogs 1-7 in columns C-I). We have approximately 50...
|
February 18th, 2010 07:29 PM
by Amylou
|
0 |
135 |
|
|
if/and array in MS Excel 2003 by
Amylou
What I am trying to do:
I have a list of 35 clients (column B), a row of 7 available catalogs (row
1: catalogs 1-7 in columns C-I). We have approximately 50...
|
February 18th, 2010 07:28 PM
by Amylou
|
0 |
149 |