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
...
|
