can the numbers in an IF statement be automatically programmed to change colors when number is negative(red for negative and blue for positive)

Okay. Pretend I'm a totally idiot and and can't seem to get anything to work right! :) Now, I have done a few macros before (basically just recording them...

Hi out there in cyberspace, I am trying to automate a workbook containing 14 sheets, each is a weight class used for wrestling tournaments. I want to be able...

I have created a payroll spreadsheet that calculates FICA and MEDICARE W/H. I formatted the cells to 2 places. The MEDICARE W/H formula calculates to...

I am working with several large excel sheets(stats, employees etc.). I am trying to tie all 4 of these sheets into 1 sheet that will pull data from the main...

How do I calculate difference in days & hours between two dates excluding weekends and public holidays. Using excel 2002

Could someone kindly give me some guidance on the below: I have two columns, one a list of dates, and the other which is supposed to show a 'Y' if the date in...

I searched b-boards for previous comments, but I didn't see any. The calculator on my desk says that 5625*0.07 =...

Hi guys, I wonder if it's possible to format conditionally a cell according to the value in another cell. F. ex., we format cell A1 like this: If value in...

Once again thanks for your help folks. Could someone show me how to write the following if statement. =IF(A1=RED OR BLUE OR GREEN OR BLACK OR ORANGE,1,0) I...

I'm using Excel 2003, The 1st worksheet is our project staff schedule the other 8 are individual's timesheet that feed from the 1st worksheet. I don't want...

I met a problem when I want to create chart by Excel add-ins for SQL SERVER Analysis. after I extracted data from some cube, I find some cells are empty. It...

I have seen about a dozen entries with that subject. I can't get a single of oneof them to work. Am I missing something? In the range n12:n1000 I am looking...

Hi, How can a range of cells that are dates be counted if the date in the cell is prior to today. -- Keith

Hi all, I'm trying to create a macro to update pivot tables with a macro. but when I create it and then try to run it, I receive the message: It' impossible...

Help! I have placed a two workbooks on a server one workbook relies on the other for data. I have changed the sources after placing them on the server and...

Hello, Is there a way to use a lookup function to another Excel File. I use Vlookups and Hlookups in a single workbook, often. Is there a similar function...

Is there a way to lock a specific set of cells and not the whole work sheet? I have several cells that have formulas in them that I do not want changed, but...

I am trying to use a SUMIF funtion in which the "sum_range" is defined as a named range of cells. If I include the range name in the formula everything is...

ello Book1 a1 has a drop down list. Book2 c3 = Book1a1. I would like to create a drop down for C3 that includes the same drop down from book1 but not...