Is there a way to use conditional formatting to highlight any cells on a
worksheet that contain a formula?

I am currently trying to update a couple workbooks and would like to
combine them into one workbook with multiple sheet.
What I have:
One sheet is a proposal sheet and I have four other sheets that depend

hi;
I have this sheet that I am making where there are 5 test results, each with
3 possible inputs. I am using optionbuttons to enter the results. So I end up
with a table that looks something like this:

Can you just throw a light on using VLookup and let me know the exact use of
this function?  Hope to get the valuable inputs from you to become perfect in
using VLookup.
Have  a nice and wonderful day,

is it possible to automatically name workbooks so that it gets its name from
ie. shell A1? Workbook is saved to prevent unwanted actions but still users
would need to name each workbook.

Hoping someone can help me with this, I've read some related topics and
couldn't apply the principles to my own problem (might take me a while to
explain)...
I record all incidents and issues that arise within our business in a

I am using NETWORKINGDAYS to find out the difference to when an item was
order and when it was actually received.  When the order date is the same as
the received date the answer I'm getting is one this should be zero as there
is no days in between.

I believe I need a Worksheet_Change code from what I have been able to
gather from other posts.  I am trying to hide (row 19 on sheet 3) if
(cell d19 of sheet 1 = 0 or blank.  
Thanks in advance for any help.

I have one worksheet from where I print my cheques, from the data from
the other work sheet, but every time i have to select the data lie (+
worksheet2, b2) etc..
I want to know wheter any formula availalbe whereby I can formaulate my

I would like a simple formula which will give the totals for a month from a
(large)list in another worksheet .

How can I have a macro auto run after every 1 minute?

Hi!
All Excel Genious,
Pls help me to any quickest alternative from this boring shortcut
*Alt,E,S,V then Enter*.

I need to create some custom number formats, but after a few failed tests I
have a lot of junk that I'd like to remove. I've checked the Microsoft
knowledge base which suggest there should be a delete button, but I don't
have one. Can anyone help?

I have a simple =MIN(A1,<formula>) if A1 is 0 the min=0 but if a1 is
blank min=formula (which resolves to greater than 0). A1 is formated as
number. Never seen this before and have no idea what is causing this.
Any ideas much appreciated.

how can i make macros to work when in tools, costumize and option are not
highlighted? please help me with macros