|
|
|
|
2 |
282 |
|
|
|
|
2 |
227 |
|
|
|
|
1 |
245 |
|
|
conditional formatting by
Teeny
I have a column of dates and I want to highlight in red all dates that are
equal to and more than 3 years old
For example if the date is 02/10/04 this should...
|
|
7 |
242 |
|
|
|
|
6 |
237 |
|
|
|
|
1 |
177 |
|
|
Using SaveAs by
SarahN
Hi,
I use a SaveAs feature for a report. there are 4 sheets in this work book in
total. The last 2 pages are summary sheets from the previous year. If i use...
|
May 14th, 2010 04:26 AM
by SarahN
|
3 |
202 |
|
|
Multiple Worksheets by
George
This is what I want to do I have a workbook with multiple sheets in it 15 to
20 with a master sheet to add up all the data The workbook needs to be viewed
by...
|
May 14th, 2010 03:25 AM
by Sheri
|
6 |
273 |
|
|
formatting cells for minutes & seconds by
kwgwynn
I need to format a range of cells as mm:ss. I've tried using the custom
format setting for cells and the values I've added are rounded. If I add a
new column...
|
|
8 |
196 |
|
|
Vlookup for 3 sheets by
tran1728
Dear All, pls help me.
I want to make a Vlookup, the data of Product est very big, Column A is
Item, Column B is Description, there have 3 Sheets for product...
|
|
6 |
258 |
|
|
|
|
3 |
274 |
|
|
|
|
7 |
204 |
|
|
DROP DOWN LIST WHEN SPREAD SHEET OPENS by
Dave
Hi
I have a spreadsheet that when you open it a drop down list shows a choice
of names to choose from that each relate to an individual sheet. How do I...
|
|
5 |
234 |
|
|
|
|
3 |
294 |
|
|
|
|
1 |
210 |
|
|
Conditional Formatting using Traffic Lights by
Ruby Pro
Would like to set up conditional formatting where I can show a green light
for amounts above 0%, yellow light for below 0% but greater than -5%, and red
for...
|
May 14th, 2010 12:22 AM
by Max
|
6 |
301 |
|
|
|
|
1 |
200 |
|
|
|
|
2 |
220 |
|
|
Cell Formatting by
Alicia
Is there a way to format a number cell to change to red fonts if less than
another cell?
Ex: Cell H2 is 29 which is less than Cell K2 which is 35.
I...
|
|
5 |
170 |
|
|
|
|
5 |
206 |