this updates a league table based on results.
Code
-------------------
   For Each myLeague In myLeague

I am looking for a formula to insert pictureA if X>0, pictureB if X<0.  I
have pasted the pictures at the bottom of my template and have referenced
those cells in the formula, but I dont think it recognizes that there is a
picture in the referenced cell.

How do I get rid of a drop down box within a cell? I have already tried
Data/Validation/Clear All, but the box is still there.
Any suggestions?
Thanks!

I'm trying to solve 2 of my excel problems :

1. a function or macro that allows to determine which font and/or
background colour were assigned due to the conditional formatting of a

I have a fairly large spread sheet that I usually filter or us a pivot table
to get what I need and then manually input into another workbook.  What I
need is to count the nonblank cells in column G (which consists of times in
hh:mm:ss format) based on column A = KM06 and column ...

I know this is easy, but I'm having a complete brain-fart on how to do
it.
I've got a column of values on one sheet, and I want to match each
individual value in that column with the same value on another sheet,

I have two spreadsheets. The first spreadsheet contains two columns, one for
start date/time (in serial format) and the second for stop date/time (in
serial format).
The second spreadsheet contains two columns. One containing a serial

I have a hard one for you.
if Sheet1 A1 is = Sheet2 A1 and if Sheet1 OFFSET from S1 down 2 left 1 is
equal to Sheet2 OFFSET from A1 down 2 left 1 return nothing otherwise IF
different return what is now in that cell of Sheet2. Then continue down until

Hi Everybody--i have a 50 +/- tabbed worksheet, I need each worksheet to
have the same headings (there are about 10 headings) underneath each
heading i have my drop down list (validations) that people need to
choose from. i need to format my whole gigantic worksheet like this,

I need to delete 1 digit and then the decimal point, so that the # in the
cell is only what was after the decimal point (ie, 1.1100 to 1100).  I'v got
about 2000 rows and don't have time to delete them manually.

I need a fucntion that allows me to count if in a range of numbers how many
are greater than (for example) 250 but less than (for example) 2000... can
Countif do this? If not, how should I go about it?

How would I reference the content of a cell instead of the result?
Example:
A1: =IF(1,2,0) (Result is 2 formatted as number)
A2: ???? (Result is "=IF(1,2,0)" formatted as text)

I have to calculate a monthly payment based on avariable interest rate.  What
is the formula I use, ex.  variable rate in is A6, loan term B6, and payment
C6?

I am trying to write a condition if one cell meets the condition (Example H5
= OPEN) then turn cells H1 through O1 to red (Color fill)
If H5 = Closed then turn Cells H1 through O1 to Green
Is this something I can do in Excel?

Good afternoon,
I'm looking to seperate inventory items into PRIME and SUB units..
Example: Sodas have are in cases of 24 so the PRIME unit would be 1. If
you had 26 cans total it would then be 1 PRIME(cases) and 2 SUB(cans). I