Also Can I only have it flash or blink when it has a negative number entered

or calculated

or calculated

- Can I make a field in excel spreadsheet required? If yes, How?
- Can I make a formula in Excel to display result in same cell?
- How can i reference a Cell in Excel with a SQL Stored Procedure?
- How can I hide a column in excel?
- How can I make a formula in Excel showing when the file modified?
- How can I split a cell in Excel?
- How can I make a formula in Excel showing when the file modified?
- How do I make a nomogram in Excel?
- How do I make a cell automatically change color/add a check box?
- Can I have a cell in my worksheet to control the number of copies.
- How do I make a cell flash
- How can I make a confidence interval graph in Excel?
- How to Make a Cell Flash in Excel using conditional formatting
- Can I make a database in Word with Excel Data
- In excel, can you make a cell blink?
- Can I add a graphic to a cell in Excel
- Can you write a formula in excel that can reference the source/or dependent cells of a specific cell?
- Can I make a scrolling section of cells within a work sheet?
- How can I get a cell to Flash if it meets a certain criteria in Ex
- How can i build up a Matrix in EXCEl ?
- Form already displayed error and Setting a Value to a cell in Excel
- Splitting a cell in Excel
- How do I create a cell with a pickbox in Excel?
- How do I set up a cell in Excel 2003 to blink

the same cell... In other words getting a formula to be locked in a cell to

where whatever info I put in the cell, the locked formula calculates the

entry number.

cannot unhide, but can still add/modify other information in a sheet or

workbook?

file and shows this in a cell, so a user opening a file can see when the file

was last saved/modified. I saw this when using SAP Business Warehouse tool

but it was probably part of the program. Is there a possibility to to

something like this with a normal excel file?

additional cells, but they need to match with a previous row...I know you can

do it in Word, can this be done in Excel

file and shows this in a cell, so a user opening a file can see when the file

was last saved/modified. I saw this when using SAP Business Warehouse tool

but it was probably part of the program. Is there a possibility to to

something like this with a normal excel file?

Can I make a cell change color when I have completed a visit?

Cells are in date format. Need something really simple and visual to see each client.

Some suggestions, e.g. when I doubleclick the cell, or if I used a checkbox or something.

Thanks

have to go to 'File' Print to put the quantity. Is that possible

flash on and off? Can it be done?

it is a function of conditional formatting. I know it is possible because I

have seen it before but I do not know how to do it.

I am making a list of area dentists that I have copied and pasted off of the Dex website into Excel. I am wondering if I can take this info and make a database in Word for printing address labels. Does anyone know if this can be done, and HOW?

be used in a merge document. Is this possible.

In other words: I label my tabs 1,2,3,etc. If I link cell A1 in tab 1 to cell A1 in tab two I would like to be able to write a formula in cell B1 of tab 1 that tells me that cell A1 is linked to tab 1. For a bonus I would like to be able to write a formula in C1 that tells me any cells that are using cell A1. For example if tab 3, A1 was linked to tab 1, A1.

To put it in to formula terms:

Cell A1 of tab "1" would look like this: ='2'!A2

Then I want to write a formula in Tab "1" Cell B1 that results in: "Tab 2" or even "Tab 2 Cell A2"

Can anyone help with this?

I have a formula that will put the name of a tab in a specific cell. This is great for tables of contents and creating titles to documents or footnotes, but it is a pain staking process to use this formula for the above purpose.

That formula looks like this:

=MID(CELL("filename",$A$1),FIND("]",CELL("filename",$A$1))+1,34)

I am currently using 2007.

Thanks to whoever is smart enought to figure this out!

What I am trying to do is make a section of cells scrollable within a work sheet.

Like say make 100 cells in 3 rows, but only display 10 of them on the screen and have a scroll bar to move down past the 10.

The idea is I want users to be able to inter a lot of data on these specific cells but I want to save room on the sheet for other things. Thanks.

I want to have a cell in Excel to blink on and off if it meets a certain

criteria.

Any ideas?

criteria.

Any ideas?

how can i build a Matrix in Excel combining 250 items (ex. airports) with

250 items (ex. airports)?

i schould create a row with the 62500 possible combinations... there must be

a formula to make this autmatically.

ex. ZHR JFK ATL ....

ZHR

JFK

ATL

.....

And then I should get a list in one row :

ZHR-JFK

ZHR-ATL

......

JFL-ZHR

JFK-ATL

.....

ATL-ZHR

ATL-JFK

thank you very much for your help.

regards

Mischa

but im trying to set a value to a cell in excel which has the code

=Value(F6)

but when a new line is inserted for every transaction, this also changes the code to Value(F7)

How can I keep it to set to just F6 please?

Also in VBA, I have allowed the user to finish the transaction and make another one however I get a error "form already displayed; can't show modally"

Thank you - you guys have been very helpful

regarding this, but they seem above my knowledge of the program. I already

have a spreadsheet set up and have a few cells that I need to split into 2 to

make them line up nicely with what I'm doing. HELP! Thanks!

simple.

I've got one Excel 2003 file used to maintain a newspaper delivery list.

Four customers have billing needs apart from the norm. I'd like to be able

to make these 4 jump out at me.

I do have very limited experience with Visual Basic in editing a few macros

for a specific MS Excel file used to maintian my pilot's logbook, but that's

it.

Any help would be most welcomed.

Thanks.