Search results for query: *

I have an excel spreadsheet which is printed onto coloured paper to form part of a published document. A pdf version gets posted on our website, but we can't find an easy way to colour the pages within the pdf copy so that it looks the same as the paper version. Any tips ?

This seems to be quite a common question on here and before anyone jumps in with a 'read the previous posts' remark, yes - I have already. Some of the answers given previously are way over my head, but I don't think anyone who asked before has been trying to do the same as me (format a range of...

I have several spreadsheets which I use with 'autofilter' to view specific records. Usually when I filter on any column text appears in the bar (immediately above 'start' in the taskbar) saying something like '15 of 279 records found' - i find this very useful. A new spreadsheet created recently...

Hi Guys, I'm sure this must have been asked on here before but my search didn't reveal any similar questions. I need to count how many records have certain criteria in 2 columns e.g. how many records have the word "Church" in Column A AND the number "1" in Column E. I can't see how to double...

I have just made up a spreadsheet to record holidays etc for 2005. I posted a question last week regarding conditional formatting on 7 different parameters and got great responses which did exactly what I wanted. The spreadsheet is now exactly how I wanted it to be, but despite containing only 1...

Hi all, I need to format cells based on 7 different criteria so the normal 3 criteria option is no use. I've read the earlier threads and copied the script given into VBE and it works, but not quite as I want it. I have 2 problems with what I've done so far :- 1. The script colours the cell...

I have a fairly large spreadsheet stored on a server which is accessed and updated by several users. I have the worksheet locked so that the majority of the cells cannot be altered by accident, and allowing values to be input into only those necessary. I want users to be able to 'insert...

An office colleague has Outlook 97 and can't get the settings so that he can format text in an e-mail (bold, underline etc) - the toolbar is greyed out. I've tried changing the mail format setting from plain text to HTML, Rich Text etc but the formatting toolbar remains greyed out. I have...

Is it possible to format a cell depending upon the value in a different cell ?

I have a fairly large spreadsheet which requires an extra column added which is to have values taken from existing cells within the worksheet. I want the new value to come from different columns in each row dependant upon values in that row. If any one can help I can e-mail a small sample which...

I want to request a read receipt for an e-mail but can't find where to select this. Have had a look but can't see any mention in 'Help' either, so now thinking that Outlook 98 maybe doesn't do them. Does it ?? If yes, con someone explain where I find the setting ? Thanks, Jock

I received an excel spreadsheet by e-mail that has something on it that i have never seen before. I would like to use it on some of my own spreadsheets but don't know what it is called so that I can teach myself. Its an extra grey space between the column headings (A,B,C... etc) and the...

If I use the wizard in Word to write a letter it automatically adds todays date. If I re-open the letter later it changes the date to the current days. How do I change this so that the date remains at the day I first wrote the letter ? Thanks, Jock