|
|
|
|
2 |
266 |
|
|
|
|
2 |
210 |
|
|
|
|
1 |
228 |
|
|
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 |
223 |
|
|
|
|
6 |
220 |
|
|
|
|
1 |
160 |
|
|
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 |
185 |
|
|
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 |
256 |
|
|
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 |
241 |
|
|
|
|
3 |
256 |
|
|
|
|
7 |
184 |
|
|
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 |
214 |
|
|
|
|
3 |
277 |
|
|
|
|
1 |
193 |
|
|
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 |
283 |
|
|
|
|
1 |
183 |
|
|
|
|
2 |
203 |
|
|
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 |
153 |
|
|
|
|
5 |
189 |