Need a serious excel formula knowledge people here.

I had created an awesome spreadsheet that is that bloody good that was spread to my officemates. I have a few formulas-cells that display specific info-text when selected, and display specific error-message when data is entered, because I limited input to ZERO characters, so overwriting is not possible. Entering values is impossible, because of the validation, however it is possible to delete the formula.

How can I prevent the formulas from getting deleted?

I DO NOT want to use common password-protection, because I want to specify the error message myself by using validation.

Anybody knows how to do this?

I have realized we can do dso analysis in excel (Days Sales Outstanding) by taking average accounts receivable during the month / net credit sales during the month and multiplying by the number of days (30 days). I can see there could be an accounts receivable if the business has its own credit arrangements with customers, however I don't understand how the DSO formula works?

How can I in outlook use multi color fonts when composing an email? Each letter needs to consist of rainbow colors. The changes between colors could occur at vertical boundaries or diagonal, or could be radial, or some other way.

I am about to submit a portfolio to my employer with the collection of single images in low resolution, watermarked and compile a PPS PowerPoint presentation.  I find the latter to be more professional as you can arrange pictures according to order, one slide with headlines to subdivide pictures according to groups.  You can even refrain from the watermarking as pictures are embedded and easier to handle.  But how to blow up pictures on power point to fill the screen?  This might be more than 100% if the image resolutions are below the screen resolution and it results soft. How to avoid picture deterioration?  Any recommendations from graphic designers? Thank you very much for hearing my problem.

Hi guys.  I just installed an Outlook yearly calendar template.  I am using Microsoft Outlook 2010 and I am now having problems since I installed the template.  When I launch Outlook, the whole PC freezes and I have to press reset so that I could access my PC again.  What could be the problem?

Hi there.  I'm trying to rename a .csv file in PowerShell then upload it to SharePoint.  I'm having an error of "cannot rename file.  It is read only".  What does this mean?  I need tips in SharePoint PowerShell rename documents.  Thanks in advance.

Hello fellow Techyv members. Is there any SharePoint marketing tool add-in that I could use for content management and usability with automated data collection? I use Microsoft SharePoint 2010 on a Windows Vista system.  Any help would be much appreciated. 

Thanks in advance.

Hi guys.  I just installed the spreadsheet assistant add-in for Excel for quick access to my workbook and directories.  Ever since I installed the add-in, Excel has been performing slowly and randomly crashes.  What could be the problem?  I have Microsoft Excel 2007 on a Windows XP system.

Hi there.  I just installed the MPP Viewer open source binary software for viewing my 2007 Microsoft Project .mpp files.  I launch the program, it opens a window then just crashes.  What could be the problem?  Any help would be much appreciated.  Thanks.

I need to send emails frequently to a large number of clients, for this I want to use excel Mailroom template.

At present I have installed windows 7 operating system and using MS-office 2010.

Also,Mozilla Firefox 11+ installed on my computer, my question is how we can integrate excel Mailroom template with Mozilla Firefox 11 web browser?