Functions

Color Me Red
A B Range Average 200.0 46.0 500.0 120.0 3900.0 1733.0 950.0 485.0 3000 3317.0 4.8 4.0 2.0 1.2 136.0 87.1 40.0 17.2 need some way to color column B red, if greater than column A I tried to conditional format but when I copy... 27 Mar 2010 09:40

using a IF statement to return a value
trying to have my formula to either give me an account number or D9 is blank return a value of "blank" =IF(D9="040410",411000,IF(D9="040428",420026,IF(D9="040403",420011,IF(D9="040405",420028,IF(D9="040407",420013))))) -- Cindy ... 26 Mar 2010 18:00

Multiple conditional formating for one cell
I have a workbook with several sheets. Sheet1 has several hundred rows of text. Some of the same text will appear in multiple rows of Sheet1. On Sheet2 I have I have a cell that allows my users to free hand type in a keyword(s) to search for in Sheet1. This cell is also has a reference name of "Special_Char". ... 29 Mar 2010 13:39

FORMULA BAR DISAPPEARED IN 2007, HOW DO I RESTORE PLEASE?
... 26 Mar 2010 18:00

I need to indicate a missing # in a series
I have an inventory list with inventory tag #'s associated with it. I would like Excel to indicate when a # in the sequence is missing. ... 26 Mar 2010 15:37

creating macros
I need to create a macros will a pull down menue for a selection. Then questions will come up with room for answer. Can someone help, please ... 26 Mar 2010 15:37

Adding and then sorting data into an already existing Excel 2007 w
HI, I've added data (pasted it) into an spreadsheet, and now I'm unable to sort all of the data together. Can anyone tell me why? I had no problems doing this with Excel 2003, but Excel 2007 won't allow me to sort the two list together. The columns are all lined up perfectly, so I cannot figure out what t... 26 Mar 2010 15:37

Date Function
If a cell has text and numeric (date) is there a way to pull the date out easily ? E.g. Product dropped off on 11/01/2009 by Michelle Smith I would like to see 11/01/2009 Thank you ... 27 Mar 2010 23:17

how do i find out what data is hidden i excel
how does one know if the data is hidden and how do i found out what data is hidden? ... 26 Mar 2010 15:37

Unable to Unlock Workbook
In my workbook it was password protected and able to be unlocked, now when trying to unprotect it the option to unprotect is grayed out 3 other clients are using this workbook and the option is grayed out for them as well. One day it was fine the next day they couldnt access it. How do I unprotect my workboo... 26 Mar 2010 13:12