I want cell D6 to turn red if any text is written in cells F6-F20.  The
typical condition in cells F6-F20 is blank.  The cells remain blank unless
someone writes a note in the cells.  I want cell D6 to alert me in red when
a note has been written.  How would I write the ...

I want to know how to remove the bexes that are in the excel? I have a
data and design and I need to removes extra boxes so it will have a
professional look? and what is the name of this feature?

Can any one tell me how to put rows and columns in to show up on a form? I
have not clue how to do this. I did a very small form, which is great for
what I need, but no rows show up when I print it. I tried clicking format
then clicked rows. I tried insert then clicked rows, ...

Anyone else notice there are exactly 65535 (one more than this magic
65536 number) of rows allowed in older versions of excel?  In older
versions of the program, this equation works properly so I believe it
has something to do with the row indexing logic.  Sounds like a cut &

Cell b1= 25 Sept 2007
Cell b2= 23 Sept 2007
Both cells are formatted as shown
With the following formula in B3 (B1-b2) I get answer of 3. I thought the

Windows XP
Excel 2003
What I am trying to do is format a string for output in a message box for
currency.

I have been trying to enable macros in Excel 2007 (recently acquired) and
though I have turned on Enable Macros and VB etc. It will still not let me
use them and I continue to get the security warning when the file is opened.
Can anyone give me an answer

I want to calculate # of hours worked in this example:
C1     10:00 am        
D1      3:00 pm
I want to display the duration of 5 hours.

I wish to maintain a dual environment as some of you do. I wish to be
able to also run XL97 just as if the 03 installation had not been done.
I plan to just answer "no" to any questions to "remove prior" during the
03 installation and plunge in. Can I trust them on that? Any advice ...

I have an interesting problem which I have been trying to solve.  I've got a
windows explorer directory full of word files which go back 3 years.  Their
file names are all well formatted and can be imported into excel as text.  I
then use excel to sort the files from the names ...

Is there any way of producing the same as a conditional format on a cell
(ie. chenge fill and font colours according to a calculated value) but for
more than three (four, if you count the default) values?
TIA

Can I display several "Sheets" at once?  I don't seem to be able to do it.
I click on <Windows>,<Arrange>,<Windows of Active Workbook>,<Horizontal> for
instance, but I only see one sheet.
Tnanks,

I know most of the posts here are for advanced users... but, please help!
I have a column of data in one spreadsheet (column A) in a workbook and
another column of data (also column A) in another spreadsheet in the same
workbook.  I want to confirm that all of the data in the ...

This problem appears to be quite a bit more serious than the Pentium
divide bug.   Will Microsoft be able to fix it (software) more rapidly
than Intel was able to fix it in the hardware?   Hmm...

I have a column of values (E3:E50) and I want to list below this column, in
a cell (lets say E52) the SUM of the top 5 highest values.
The glitch (as there always is one) is that I don't want every cell to be
considered - I only want, for example, E5, E8, E11, E14, E17, E20, E23, ...