Functions

Is there a formlula to replace cell shade color with another color
Is there a Find and Replace type of formula where which will find cells with a formatted with one pattern color and replace them with a new pattern color.? ... 9 Feb 2010 05:06

Arrange Footer
I have a file with 31 sheets and every sheet has a footer ABC 6/1. How can I arrange this footer in all sheets to ABC 6/0. Thanks in advance. ... 8 Feb 2010 19:09

stop view and lock columns
Hi, I need to hide two columns on my worksheet such that when I send it to a user, they cannot "unhide" the columns to see salary data. Is there a way to hide columns and deny access to other users? Thanks so much! ... 8 Feb 2010 16:51

insurance renewal formula flag needed
I need to flag a reminder for myself a couple weeks in advance to renew insurance policies. How do I set this up if: C1 D1 E1 Jane doe insurance exp.date "renew insurance" I need the formula in column E. I can get it to remind me o... 8 Feb 2010 16:51

symbol definition
what does the following symbol stand for ^ ... 8 Feb 2010 12:16

Excel autofit row height not working
Question is on a problem I found posted in internet many times, with NO proper answer. Postings dates range at least from 2001 up to 2010. Text is not short, but I have seen many long threads just to get all (or part of) this information together. I work with Excel 2007 (occurs with previous versions as well) an... 8 Feb 2010 10:00

Removal Date
Dear Experts, Please help for the following condition: 1. I have one sheet "A" which contain of database, the field structure as follows: Field A = Date Field B = SN Filed C ... I have a lot of records, which can contains the same SN (Serial Number) but with different Removal Date. 2. on the other ... 8 Feb 2010 11:07

Pivot Tables: Don't show data for detail, but still show subto
Thanks Herbert, I'm using Excel 2003, so not sure if its not converting properly - it looks like you've got it to the same place I do, but I need the Budget and Difference to disappear at the employee level so it just shows the totals for those columns. The only column that should have the detail is the 'WTE' ... 8 Feb 2010 07:48

IF FUNCTION
I need to match criteria in two separte columns and then the third colum with be fixed text if the criteria matches eg A1= Yes and B1=Yes then C1(column with the formula in) would show "Generate Letter" ... 7 Feb 2010 20:56

Time format shows default of 12:00 AM
Following up on the suggestion, using your recommendation " =IF(ISBLANK(Sammy!E11),"",Sammy!E11)", and I got an error message "Please use the following format for entering time 12:00 AM". I have formatted both cells for time. Any suggestions why this error message is popping up? Thanks for any help. "... 7 Feb 2010 13:09