Browse Site by Tags - Excel User Group

Video Tip: Conditional Formatting and Data Validation

Today's author: Sam Radakovitz, a Program Manager on the Excel team that enjoys creating VBA applications in Excel. A bit ago, Joseph had a blog post about community clips on OfficeLabs.com , so for this post, I wanted to take advantage of the video demonstration and do the post via community clips...

Posted to The Excel Team Blog (Weblog) by Anonymous on Fri, Sep 5 2008

Using Excel 2007 for Progress Tracking in the Classroom

Today's author, Danny Khen, a Program Manager on the Excel team, discusses a solution he recently built using Excel. The Manual Spreadsheet Spreadsheets are the bread and butter of running the business world, where PCs are ubiquitous. The possibility, indeed even the need, to use spreadsheets in...

Posted to The Excel Team Blog (Weblog) by Anonymous on Thu, Aug 21 2008

Re: Trying to link cell contents to another cell

bman1965 Simply, you can't bring through formats with a function. It can be done with code but it's complexity will depend on the number of different formats you are wanting to handle. What it appears you want to do though is use Conditional Formatting (C/F) throughout the workbook and whatever...

Posted to General (Forum) by Nick Hodge on Wed, Jun 18 2008

I want to create a standard deviation bell graph

Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks

Posted to General (Forum) by vanse@hotmail.co.uk on Sun, Mar 30 2008

Re: Duplicate Conditional Formatting Rules

@Nick: Paste Special -> Formats works fine if there are no other formats for the cell you wish to preserve, such as number formats, borders, or other aspects of the format you are not adjusting conditionally. @Anonymous: A technique I often use to copy conditional formats (in Excel 2003) is to: Select...

Posted to New Features (Forum) by Rick Williams on Thu, Mar 27 2008

Duplicate Conditional Formatting Rules

It would be very helpful to be able to duplicate conditional formatting rules as a basis for making a new rule, or to get the original rule copied into a new sheet in the workbook. Having to make every rule up from scratch means a lot of clicking around to set formats and such which could be easily copied...

Posted to New Features (Forum) by Anonymous on Tue, Mar 25 2008

Re: Changing cell background color automatically

Brad Sure there is, check out conditional formatting in help (It's under the Format menu)

Posted to General (Forum) by Nick Hodge on Tue, Mar 11 2008

Re: expanded icon sets in V Next: Less is More.

Michael That's a good plan, I never thought of less, but I suspect we will see some work here in V.Next as it is a little under-cooked. Whilst it is tough to represent, I would also like something to show deciles graphically. We use that all the time here in mail order. It's the opposite end...

Posted to New Features (Forum) by Nick Hodge on Wed, Feb 20 2008

Re: Conditional formatting with diagonal border

Interesting, I hadn't noticed that and can't think of a reason why it doesn't work. If you were looking to show something as no longer available, you could use a strikethrough effect

Posted to Fixes (Forum) by Nick Hodge on Tue, Feb 12 2008

Tracking Split Costs

Today’s Author: Joe Chirilov , a program manager on the who has done a lot of work on both the Excel and Excel Services teams. Joe is going to discuss a spreadsheet he recently built using Excel 2007. Recently a large group of friends and I went on a multi-city tour of Europe that lasted a couple weeks...

Posted to The Excel Team Blog (Weblog) by Anonymous on Wed, Nov 28 2007