I want to set a conditional format so that the formatting will show only if
BOTH conditions are met.  Condition 1: B5>20  Condition 2: B5>C5*1.5  I am
using XL 07.

I am a long-time user of Outlook now using Office 2007 with Vista.  I have
two email accounts that Outlook refers to with each Send/Receive.  The
problem is that each time I send a single message from either of the
accounts, Outlook states in the status bar that it is sending the ...

Hi All,
Can someone please help me.
Im doing a very simple formula
=D5-C5

I'm very very new to pivot tables - and i was wondering if it is possible to
have an empty cell next to the information that I can enter stuff in to
correspond with the item showing.

I'm running a simple sheet where i have invoice numbers running down column
A, and dollar amounts for that invoice running down column E.  I can vlookup
any invoice number and get the amount for that invoice, but I'd like to type
in 2,3 or 4 invoice numbers into 1 cell and have ...

2007
In the last week, my Personal.xls has stopped booting up after almost 2 years of all OK
The file is in:
C:\Documents and Settings\MyName\Application Data\Microsoft\Excel\XLSTART

Hey Giggs,
Could you help me to enter 2 lines text in a excel cell without using space
bar. Like we can write in Word. By pasting the texts coped from word, it
works, but i wanna know whether we can enter 2 line texts in an excel single

I wish to remove the tax component (10%) from an invoiced amount.
I can do it in two steps, but i'd like it done in one.
i.e    A1                B1
     $120.00        $109.09

If I have the discounted price and the discount percentage that that price
represents, what formula do I use to find out what the original price is?
For example:
The discounted price is $24.23

Hello
i want to create a spread where i input the 6 lottery number into say a1 b1
c1 etc
and have my list of lottery numbers (4 rows of numbers or more) highlight

i have a defined completed spreadsheet that I want to add another column to.
How do I do this?
I am new to Microsoft Excel
wendy

Generated new columns by formulas, but now when merging with an existing
workbook, I get this #REF entry due to the fact that the formula is not  
there any more. What is the solution around this hiccup?

How can I conditionally format a cell based on the value in a different cell.
I have two columns of information. None of the information in the cells I am
trying to format is numeric. I am trying to track names to loans that are
with the company. If they wrote outside, I need to ...

I need to write a formula that allows me to look up two values in a series
of vertical lists and then returns a total value (sumif) from the same table
array that statisfies both criteria.  
Something like a vlookup and an AND and a SUMIF althogether if there is such

WHEN I GET ANSWERS FROM PEOPLE IN E-MAIL. THE SHEET COMES UP BLANK.
I OPEN THEM AND IT IS BLANK
                                        PAUL