some kind of Conditional format? - Baffled :( Hi all, I've got an issue where I need a formula that when I put a date (or any value) in cell A1, the text 'Closed' is automatically entered in cell B1 - I'm sure I've seen it somewhere before (probably used it too), but I've searched in vain - can anyone help? TIA Dave ... 26 Jan 2010 22:19 Average % - this should be easy? Hi, I work for a charity organisation. Every month we raise more money than the previous month. Can someone assist with how to work out an average increase over a few months. My donation amount column is formatted currency, but I need the answer to be an average percentage increase. Thanks. ... 26 Jan 2010 06:33 lookup function how can I set up a lookup that will insert jpegs into a cell range. The jpegs are currently listed in Windows photo gallery ... 26 Jan 2010 01:09 Conditional Format - If day = 24 or 25 Hi All, Is there a way to format a cell based on the day of the month? I'd like the cell colour to change if it's the 24th or 25th of the month. Thanks if you know. Michele ... 26 Jan 2010 05:28 How can I keep a zero (0) at the front of a set of numbers. I want to keep the cell as a numerical number not in text format. I am trying to set up bank account numbers in another system taking the raw data from excel so need the zero at the front. How do I keep the zero? ... 25 Jan 2010 20:45 Locking Cells I'm trying to keep the first several rows from re-sizing when I size the rows below. Does anyone know how to do that? Thanks. -- RT ... 25 Jan 2010 13:58 Sum Workdays Solutions first one didn't work second one did. /!\ I had to replace "," into ";" Below the working formula: =SUMPRODUCT((WEEKDAY(A2:A32)>1)*(WEEKDAY(A2:A32)<7);B2:B32) (thanks to Jacob Skaria) alternative: =SUMPRODUCT((WEEKDAY(A2:A32;3)<5)*1;(B2:B32)) (thanks to Mike H) Dutch: =SOMPRODUCT((WEEKDAG(A2:A32)>1)*(WEEKD... 25 Jan 2010 08:19 Weeknum in 2010 incorrect Hello, we encountered a faulty weeknumber generated by MX Excel for all dates in 2010 as of Jan 3d, 2010. This should be weeknumber 1 until January 9th, 2010 but MX Excel uses weeknumber 2. As a result all consecutive weeks in 2010 are numbered 1 week too high. Would be nice if MS could issue a repair patch! ... 26 Jan 2010 21:14 Countif problems I am currently trying to write a formula that looks up a centre eg Boston and then, from another column, how many 'Bostons' appear between two given dates. Is this possible? Although I am writing this formula other people will have to use it and change the date ranges regularly so it can't be overly complicated.... 25 Jan 2010 07:14 Error Alert for Invalid Data doesn't work for data selected in col Good afternoon everyone, Just as a basic introduction, My name is Gene, and I'm working at a company producing a CRM database, which includes an Excel template file that I provide the employees to fill in so that they may fill in the contact details while away from the database and add them whenever possible. ... 24 Jan 2010 23:38