EXCEL - Can anybody show me the specific keystrokes to direct a cell to be a
certain color pattern based on the following example?
If the entered data in B1 is > data in A1, then make the color pattern in B1
Green

Can someone help me shorten this formula, without having to change the
path location of the linked sheet in the formula or without having to
use additional cells in either sheet to do the calculation?
The result of the formula only shows up if I have the linked

does anyone know how to use validation to look at two columns at the same
time ?

I have been using this formula to subtract 2 months from D15, it also gives
you the last day of the month, i.e. if D15 was May 31, the formula gives you
Feb 28 instead of Feb 31.
=MIN(DATE(YEAR(D15),MONTH(D15)+{-1,-3},DAY(D15)*{0,1}))

I want to set up a lookup command based on two criteria.  I'm not sure which
step to take.  The table has a column range of A:M and a row range of
6:711... My Table is set up as so:  
  SAZ           Housing        2006/07        2007/08        2008/09

  I'm trying to create an excel formula to give me the maximum repeaded
value in a range of numbers.
example:
5                          I need to know the maximum value that occurs more

Alright everyone, I know very very little about programing a function in
Excel.
Now that we have that out of the way this is what I'm looking at.
My boss gave me two excel sheets one is 626 rows and the other is 13000

excel cannot accepted the password and finily cannot open file pz give the
suggestion file open asking to enter password
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the

I have a total cell that I can add or subtract from.  Any ideas?
My math is as such  IF(A6-A5>0, K2=K2-B5)

I'm back and needing some assistance.  I tried to do a Search on thi
to see if there was already an answer but wouldn't work.  So here w
go.
What I'm trying to do is the following:

I have a problem with getting conditional formatting to work properly for
me.
What I want to do is use the cell background colour to indicate the number
of items in the cells (column)

I am an old die hard. Just updated from Office 97 to Office xp. Believe me
I'm no whiz.
The function bar in 97 had and x a checkmark and and equal sign.  This
totaled all figures in the cell.  Now I only have a fx and I have no idea how

I have a very basic knowledge of excel so please forgive me if this is
actually ridiculously easy to do.
What i'm trying to do is this:
I have a basic addition formula in A1. What i am trying to do is have

Hey. Heres what I want to do:
I have a worksheet that has dates of when I need to do things, kind of
like a calender. Is there a way to change the color of the text when
the date approaches? Please help me!

Not sure if this can be done, but you never know.
I have a spreadsheet which imports data from various other
spreadsheets, using simple formuals like:
=C:\folder\[spreadsheet.xls]Book1!$Y$12