I would like to turn all cells a Fill color (e.g., Red) based on the value in the first column of that row.

Sorry. . not incredibly versed in Excel lingo, but trying to create a summary page and when you click on the name it will automatically take you to the...

Here is the problem. I have members (over 900) in my spreadsheet that have taken annual classes on different dates throughout the year Each class is due...

I'm trying to do this, but am having difficulty. Is it because my names ranges are dynamic using Offset to define them? I'm guessing my only alternative...

PLEASE EXCUSE MY NOT FOLLOWING PROPER PROTOCOL FOR SHOWING MY EXAMPLE, I AM IN A HURRY AND IT IS MORE LOGICAL TO ME THIS...

I know the subtotal function will not work with horizontal ranges. My question is what can I use to substitute it? I have a horizontal output data table,...

We are working with some pretty good size worksheets that have multiple formulas. How can I change a reference in several formulas all at once, without...

(moved from general) I am trying to take the data from the Races sheet and have certain parts counted, summed, or averaged by track into the Track Stats...

File 1 has a trial balance on it for May08 File 2 has a trial balance on it for June08 File 3 has a trial balance on it for July08 Separate File 4 has 3...

In the help file it says you can link a pop up menu (data/validation) from a list in another workbook if you create a name in your worksheet and you link...

I am trying to modifythis formula so that it will return "NA" if the value in B24="NoAction" =IF(IF(Q24="Buy";S24-AG24;AE24-S24)=0;"Yes";"No") Thank you in...

Ok... here's what I need to do. My company has MANY spreadsheets, currently, that house our data. We record all aspects of our project in Excel and run all...

I am trying to sum data using the sumif function =SUMIF($A$1:$A$714, "=396??.50", $B$1:$B$714) (Criteria range, criteria, sum range) The criteria range isan...

A while ago, I was able to write a formula that allowed me to use the "if" function to format a cell a specified color. If the condition of the if statement...

I am trying to upload an ASCI file from EVOLUTION and I want the column headers to run down the left hand side of the page not across the top - is there a way...

Would appreciate help with the following: Sum column B where name in A:A = A1 and B:B 10. Result for John should be 9. Once formula points to Mark, his...

Fist, thank you for your help. I have this array formula in Z2: {=IF(AND((AG2)="S",(AH2)="S"),"Y",IF(OR((AG2)="U",(AH2)="U"),"R",IF(AG2:AN2="S","G","R")))} but...

I have a spreadsheet that has names starting in B2 through DH2. I want to sort B2 through DH2 alphabetically, while keeping the information through row 108...

I am designing an invoice and I want to put with word-art the initials of my company in the background. and when I make the invoice whatever I write has to...

I have a workbook where one worksheet holds the raw data the multiple other sheets reference in calculations. I left this workbook empty as I pulled out and...