Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Excel
123quattro
charting
crashesgpfs
datamap
excel
interopoledde
links
misc
newusers
printing
programming
querydao
sdk
setup
templates
worksheet.functions
  
 
group : microsoft.public.excel      view archive
page nr. << back    20      21      22      23      24      25      26      27      28      29      30      31      32      33      34      35      36      37      38      39      40    next >>



Conditional Formatting     Mon, 15 Feb 2010 08:13:52 -0800
I have a date field (birthdates) in column B In column A I do math on that date field to arrive at age (Today()-C3)/365) - (Not very accurate but works for my needs) I would like Column A to be conditionally formatted based on the Date (month and day) in Column B. I want the text to turn RED if we are approac ...

Open HTML file in VBA using workbooks.open     Mon, 15 Feb 2010 06:04:45 -0800 (PST)
If I open an html file from VBA, for example.:- Set WB = Workbooks.Open(sFullFile, 0, True) ' 0=do not updatelinks, true=readonly a new workbook opens with the html file in it as expected, but some text is automatically converted to date format. For example 03-4703 becomes 01/03/4703 or 03-Mar. Can I open ...

How do I display an empty cell and calculate on it     Mon, 15 Feb 2010 05:48:01 -0800
I am using a reference on one sheet to fill the values in another. If a cell has not value it I want it to be blank. But I also what it to be used in a calculation when it is populated. I have tried nothing, but it enters a 0, I have tried =IF(Data!C2>0,Data!C2,""), =IF(Data!C2>0,Data!C2,null), =IF(Data ...

Excel 2007 Filtering Options     Mon, 15 Feb 2010 04:07:02 -0800
I am running Excel 2007 and when i filter a list and then highlight the filtered results to cut and paste into another application, it also paste's the hidden information from the filtered list, so i am getting everything instead of just the filtered results. Does anyone know if there is a setting i need to s ...

refer to a range / block of data on the same sheet     Mon, 15 Feb 2010 09:40:04 -0000
Hi all I wonder if someone could please help me solve this issue, i have done examples files to help someone look at this issue *********************************************************************** Example files : 2003 http://www.bradrail.co.uk/uploads/pricelist/exampleprices.xls 2007 http://www.b ...

Work at Home- Earn $4,000 Weekly With Email Reading Jobs     Sun, 14 Feb 2010 23:19:45 -0800 (PST)
Work at Home- Earn $4,000 Weekly With Email Reading Jobs Get Paid $5 For Each New Sign Ups - Easy To make Money Make More Than $200 A Day , Register Now To Start earning At http://moourl.com/lvi7k ...

Conditional Formatting formula (one cell matching another with tex     Sun, 14 Feb 2010 14:19:01 -0800
I NEED A FORMULA TO DO THIS: IN D18 TURN TEXT RED IF IT DOES NOT MATCH CONTENTS EITHER G7("DAYS") OR H7("HALF") MEANING IF D18 HAS TEXT, IT HAS TO MATCH TEXT IN EITHER G7 OR H7 OR TEXT IN D18 WILL TURN RED ...

What is this feature called?     Sun, 14 Feb 2010 13:51:13 -0500
Rcvd a spreadsheet the other day that has many rows of date in groups. Rows in Group A, followed by Rows in Group B, etc. At the far left, left of the "A" column there are parenthesis-like brackets each with its own compress-expand radio buttons. One parenthesis groups all rows in Group A, another for Group ...

Select certain cells in a column     Sat, 13 Feb 2010 20:44:10 -0600
I need to copy certain cells in a column and past them into a word document, but when I select them by using Ctrl+C I can select the individual cells but when I try to paste them into word I get all the cells between the first and last. I have tried using both paste and paste special. What I mean is I sele ...

Bugs in Excel 2007 sp2 scatter graphs     Sat, 13 Feb 2010 14:41:01 -0800
Hi, Just wondering if anyone has ever found a repair for the (serious) bug in Excel (made worse in SP2) that affects charting when you use two independent y axes and have manually set scales? I reported this bug a long long time ago and it was recognized as a reproducible issue (slowing Excel 2007 down to a ...


page nr.: page nr. << back    20      21      22      23      24      25      26      27      28      29      30      31      32      33      34      35      36      37      38      39      40    next >>
Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us