How do I write a formula that only returns values with a certain type of formatting,Let say I only want it to return all the value that is in red.

I would like to print worksheets depending on the value of B2 (in Sheet1). If B2 = "pens" or "paper" Then print Sheet1, Sheet3 and Sheet4 If B2 =...

Hello trying to find a way to have a row of dependant columns ,where the first row has a drop down menu with a list of parts like a lamp body, then the next...

Hello Excel users and Experts, Excel 2002 SP3 I'm stumped on error handling in this code. If there is no number entered in the Input box I get a type...

I need to get a notification when i enter a data twice in the work sheet.

I have VBA project written quite sometime ago which I now need to edit it. I still remember the password, but I can't unlock it. I got a "Project Unviewable"...

HI, I have a sheet like this: Tom A 5 Tom A 5 Tom B 5 Jim A 5 Jim B 5 Can you...

Hi all Thanks for the info on the drop down lists - has worked perfectly The other thing I want to do is assign a value to the items in the list For...

In cell A1 I have the admission date to a longterm care home- eg. 05/30/2001. In cell B1 I have the birth date - eg. 02/23/1924. Can some guru give me a...

Is there a formula to do this? If cell B2 = pencils Put an "X" in cell B7 If cell B2 = pens Put an "X" in cell B8 If cell B2 = erasers Put an "X" in cell B9

What formula would I use to say: = if , = if , when cells , , and are dollar amounts, and is actually the word "yes" or "no"?

Hi all Was wondering if somebody could give me some clues on how to insert a drop down list into a cell (if this can be done) This list will contain the...

I have a spreadsheet that holds inventory items, quantity & cost, my partner has the same. We would like to upload it to a website and make it interactive so...

I have 100 numbers (1-100) that are tickets. Since you really can't trust anyone i want to make something that won't let you use the same number twice. so if...

I have a column that could produce 1 row of data or 35 rows of data. How can i consistently sum two fields below last cell with data and have...

I want to run a bunch of trials with random numbers. Each trial will have a single numerical result (in a single cell). I'd like to be able copy the result...

If you have a link reference in cell A1, then remove the quotes from A1 in your formula. =HYPERLINK(A1,"test") "Peter Ramm"...

What is the easiest way to convert an excel spreadsheet of contacts to a file that can be readily imported into a yahoo adress book?

How can I add a period to each row in a column for middle initials (middle initial only column) that were entered without a period?

I have a Lotus 123 program in my computenr and Windows XP. However I cannot acces or open Excel pages sent to me online. What can I do? Thanks.