Dear sir, i want that when C1=Suleman then next 4 or how much i selected cell change the colour . and one more question i am useing that formula...

I have a sheet set out like the following: A B C 1 9 9 2 6 3 3 4 4 I want C to show if values are matched i.e. "matched" or "unmatched" (True...

How can-I format a cell so that the result of an addition (in dollar format) does not display $0.00 when the result is $0.00

Help! (running Office 2003 on XP) I am trying to calculate 11 workdays from a given date. Some holidays we work, some we don't. We shut down for up to two...

I protected a sheet in a workbook, and check off "allow other users to format cells" Upon emailing the file to another, she is unable to change the fill...

Hello, with 2007 when you type in a formula it autofills down for you. I think this is a great option... but not for the report I'm working on. How do you...

I am trying to do a spreadsheet and keep one cell as a constant number for my formula. Where do I put my cursor to hit f4? Karen

Is there a file I can copy that would allow me to keep the options/customization I've set up with Excel if it is reinstalled? My employer regularly...

example: ( to day) ( to date) (total ) 1 2 3 now if the next entry to ( to day) is 3 & entry to (to date) is 4 the...

Hi, I have one worksheet with vertical and horizontal page breaks. I am trying to insert different page numbers in the worksheet. For example Page 1 to Page...

It's Friday and my brain has stopped functioning, I have two worksheets, WS1 and WS2, what I need is on WS1 in cell F8 to look at the number in cell N6 and...

I want to use/create a number format that will display the results of the cell as an angle in degrees, minutes and seconds (0°00'00").

I have a very basic question about how to express a certain range of rows that I wish to delete in a macro. It's not tricky (I don't think), I just haven't...

I have an Access report that is output to an excel file. I open the excel file and do a data create list so I can do a custom sort. The field I am trying...

I have a spreadsheet that is used for opportunity tracking (forecasting). In one situation, there may be multiple selections. To begin, I've created a "data"...

Can anyone point me to a link that might have an explanation of how to read a folder and present the file names in a drop down list or a combo box ? Thanks...

Hi all I upload a new version of my Table Tools Add-in today with a lot of Date filter options and error checking for the 8192 areas limit in Excel. If you...

Is there a way to do a vlookup and have it return all different values instead if just the top most value? Thank you, amy

Hi, I have the following Macro that I have a question on. The filename ("XX-TEST-0301.xls") will always be a different name, how can I update the Macro to...

I created a report with different tabs with various data. I downloaded one report and moved the information around and used that as my base. I finished...