|
|
Conditional formatting of date-cell - 2007 by
UlfHJensen
I would like to conditional format cells - in colors - containing a date if
date in cell is before or after TODAY(). This is not - strangely - an option
in...
|
|
5 |
214 |
|
|
|
|
2 |
208 |
|
|
Sharing a workbook in excel 2007 by
Susan
I have a workbook that i have created in excel 2007 with macros. I need to
allow sharing now. I understand macros can not be viewed or edited which is...
|
April 21st, 2010 01:09 PM
by Susan
|
0 |
238 |
|
|
Mandatory/Compulsory by
Md.Siddique[_2_]
Hi Sir,
I need to put a formula for a cell as mandatory/compulsory it has to fill,
otherwise it will not go to the next cell. It has to display (customized)...
|
|
2 |
175 |
|
|
find and copy it.. by
reza
hi all...
hoping u can help me for saving my time.
i have a master data in sheet 1 with more than 1000 rows.
and now in sheet 2 i want to copy data from...
|
|
2 |
258 |
|
|
|
|
8 |
253 |
|
|
Help with setting a "not found" statement by
Pierre
Hi.
I have a form that looks for a asset on a s/sheet list. What I need is a
statement that checks to see if the asset is on the list and if not, creates
a...
|
|
3 |
237 |
|
|
using Sumproduct with named ranges by
Jenny S
Hi,
Hope someone can help.
I have named ranges in tab 1, Column E=B is for Branch, Column F=G is for
Game, & Column G=P is for points. Named ranges are...
|
|
1 |
239 |
|
|
hide columns before printing by
Jean-Paul De Winter
Hi,
Before actually printing my sheet I want to hide column A and B.
Can I do this automatically without having to hide them manually?
Thanks
--
Mvg.
|
|
6 |
321 |
|
|
Seperate data by
JJ
I need help please. How do I go about to seperate data in one cell ex:
A1
1-------2-b0-40810
A2
2-----------1-03-0060
I typically want...
|
April 21st, 2010 10:01 AM
by JJ
|
5 |
265 |
|
|
Simple Yes/No drop down box by
Debi
Hi, I am looking to create a simple drop down box which has yes or no as the
options. For the life of me i can't remember how to do it.
Thanks
|
|
2 |
235 |
|
|
|
|
0 |
181 |
|
|
Unusual Date Format by
Grey Old Man[_2_]
I am writing an Excel 2002 template. Two columns of dates (date from and date
to) are both imported from an external source. The date format is 'cyymmdd'
so...
|
|
1 |
215 |
|
|
Unusual Date Format by
Grey Old Man[_2_]
I am writing an Excel 2002 template. I am importing two columns of dates
(date from and date to) from an external source. The date format is 'cyymmdd'
so...
|
|
0 |
190 |
|
|
Search and Replace, or Add New Row by
GEdwards
I am using Excel 2003.
Worksheet1 contains columns
(A) Invoice
(B) Name
(C) Address
(D) P.O.# ... and others.
I need to perform a search of column A...
|
|
1 |
204 |
|
|
Visible Shapes in a frame? by
Pas
Every time I exit design mode, the shapes in a frame disappear behind the
frame. Is there a way to stop that from happening?
|
April 21st, 2010 08:13 AM
by Pas
|
4 |
191 |
|
|
Calculating Sum Series by
deluth
Greetings,
I can't seem to find a formula to do series of sums. I would like to
calculate the following series:
For n = 0 to n=B1/B3
sum:...
|
|
1 |
234 |
|
|
|
|
1 |
246 |
|
|
|
|
1 |
234 |
|
|
|
|
1 |
242 |