Summary: I have the following query: E.g. I have 10 cells with either of the following values: "High" "Medium" "Low" I need an IF condition where I could fill ...
Summary: Hi, The formulas for conditional formatting that DerbyDad03 gave you do work in Excel 2007. Maybe you didn't enter them correctly. Excel 2007 has a lo...
Summary: How to get the Template exactely as I want it? The problem: Made lots of charts, that now need chang of axeis title What I tryed so far: made one char...
Summary: When I copy formulas, they are not updated as they are supposed to, ie. when copying a formula like =A1 from B1 to B2, the new formula in B2 becomes =...
Summary: Webpage content saved as .xls file has no problem while opening in excel 2003, excel 2000. but while opening in excel 2007 its giving the below warnin...
Summary: I'm trying very hard to figure this out. I have a workbook with about 8-9 different worksheets at any given time. Two of the sheets (which are not n...
Summary: I have a cell on a worksheet named "EDATE". In this cell is a date that corresponds to the date of the end of a week. The data table below contains a ...
Summary: Hi all, does anyone know how to do this? In Excel 2003 I used the function "URLEncode", but it seems this no longer exists in 2007. Many hours search...
Summary: Hi, I have a MS Excel spreadsheet and sometimes, and it's random, when I try to select ONE cell, there's either 3, 4 or 6 or maybe 10 or at worse 13 r...
Summary: I'm trying to add a new database query to an Excel spreadsheet. I select 'MS Access Database*' under 'Choose Data Source' and I get the select databa...
Summary: We are GOING CRAZY! We have a column of dates in a HUGE Excel file, and when we copy of paste, paste special, values, Excel is automatically changing...
Summary: i have macro made in 2003 and I can not run it in 2007 excel bellow is the macro please advice, wbn = ActiveWorkbook.Name 'Workbookname srv_loc = ...
Summary: I am downloading S&P500 data from google finance in my excel, using automatic refresh, with a frequency of 1 refresh per minute. Challenge is: I wa...
Summary: Hi Guys. I am not good at excel but there is something I want to achieve in excel, I don't know if it is possible but here is what I want. I want a cl...
Summary: I made an Excel Spreadsheet that is a list of products, the number of each product, and the value of each. What I want to do is use conditional forma...
Summary: I'm trying (and failing) to nest a complex IF and AND formula.. Here are the details: H..................I.................J Rule #1 .......Rule #2.....
Summary: I am working with an Excel workbook that contains two sheets. On the first sheet, I have several columns of information about departments participati...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
