I am attempting to compare multiple fields in a conditional formatting
formulat but am not sure how. For example, the following generates an error
when I attempt to save it:
=IF($F2="",,TEXT(TODAY() and $L2="PSR","yyyy-mm-dd")>$F2)

My husband was revamping a spread sheet at work and somehow added 2
dark horizontal lines (column lines).  He highlighted the whole column
so it goes on forever.  How do you eliminate the line in area where no
data has been inputted?  Also, how do you change the dark line to a

I am taking a course for advanced excel and I need help with a
question>
I am working on a spread sheet for real estate.  I am supposed to set
up a formula using NESector and CornerLot classifying them as shown

I have a column with 25 values in it. I would like excel to SUM eight of
these cells to a total value of 360 or less. The eights cells needs to
be identified and the total must be as close a possible to 360. Is this
function possible in excel?

I am quite new to Excel!
I can change the appearance of text using bold, italic and underline but am
having problems with colour. When I select an active cell and click on a
colour nothing seems to happen. If I go back to the cell and double click it

I've been playing with the autofilter function with no luck, maybe
there is a formula that can help me do this ->  I am trying to sort a
table (there are about 240 rows and many more columns) such that any
row that has a value > .615 in it, anywhere in that row, can be

Hi I am doing GCSE ICT at my school and I am making a 'School Shop' for
my coursework. What I need is to do is use the Validation Warning
Message and the SpinnerButton to set that off. But they seem not to
work together. :confused:

I have a datasource where the SQL Server data type for a date column is
varchar(10) (i.e. yyyy-mm-dd). I need to compare this to today's date ( ex.
=today()>$f2, where $f2 is the varchar(10) date field returned from SQL
Server ) but am not sure of how to do it. Should I convert ...

The formula shown below was working fine.
But as you can see for example between 0.75 & 0.8125 there are possible
input that will give an error message.
=VLOOKUP(I9, INDIRECT(VLOOKUP(D9, $P$1:$Q$9,2)),2,FALSE)

Looking for help to - Find text, replace with carriage return in cell.
Previous posts most helpful in converting badly formatted Word table to
formatted Excel worksheet.  The goal is to copy bulleted cells in Word
to become bulleted cells in Excel.  I replace ^t^t and ^p with "zz" ...

Hello! I have 2 spreadsheets of data (they are lists of attorneys with their
name, phone, address etc..) and I want to check to see if they have the same
information, or if one is diferent from the other and what fields, if any,
are different.  Is there an easy way to accomplish ...

The issue I'm having is formatting of linked text. I'm not even sure if
this is possible using excel.
I have 3 worksheets within a workbook. One sheet has a few hundred cell
full of text that I can move around. A second sheet links the data

When I open Excel how do I get it to display the last document I looked at
when I last closed it.
Thx
Don

For Example say cell A1 requires a password for the rest of the
spreadsheet to work and this password can only be input correctly 5,
then the spreadsheet stops working.
Is the a way to do this?

hi, i'm trying to have a cell reference in an equation following a
moving data point ...
Assumption #1 - column A has data A1=1, A2=5, A3=3
Assumption #2 - column B has an equation referring to the "3" in A3