In MSoffice for Mac 2008. I have been using Excel 2007 for windows for a worksheet that requires 7 conditional formats, to apply colors to a cell, but Mac Excel only allows 3. Submitted: 8 years ago. Create a List in Excel 2008 I was surprised to find a List Wizard in Excel 2008 (Mac) because Excel 2007 (Windows) has Tables, and had already been out for nearly a year when Excel 2008 was released.

Not enough detail to answer. Basically, you do it the same in Excel 2008 as you do on the PC. Search for 'duplicate' in the Excel Help and it shows two techniques. Give me more detail on what you need and we can be more help. On 6/06/10 12:45 PM, in article 59bb96fd.-1@webcrossing.JaKIaxP2ac0, ' wrote: -- The email below is my business email -- Please do not email me about forum matters unless I ask you to; or unless you intend to pay! John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer, McGhie Information Engineering Pty Ltd Sydney, Australia. Ph: +61 (0)4 1209 1410 mailto: jor.@officeformac.com 6/6/2010, 10:48 น. Let me try this again I use excel to manage pipe ID numbers.

These numbers are received from 6 separate pipe yards. I have all ID numbers in a column where I want to identify if I have entered a duplicate value/ID number by using conditional formatting highlighted cell rule, duplicate values. In Excel 2008 under conditional formatting there is no selection for Highlighted Cell Rules, Duplicate Values. There is equal to, greater than, less than etc.

I would like to know if there is a way to identify (highlighted cell) if I enter a duplicate value by having Excel identify this and warn me I already have this value in this column. On my PC I have Excel 2007 which has the option to select duplicate values. If this is possible in Excel 2008 please advise how to do it because I can not find it. Thank You for your reply > Not enough detail to answer. > > Basically, you do it the same in Excel 2008 as you do on the PC. Search for > 'duplicate' in the Excel Help and it shows two techniques. > > Give me more detail on what you need and we can be more help.

> > > On 6/06/10 12:45 PM, in article 59bb96fd.-1@webcrossing.JaKIaxP2ac0.

Excel 2007's data visualization feature automatically gives every cell in a range a color, icon, or data bar according to its value. If you are analyzing a small number of values, this makes it easy to see which ones met your target goals. But what if you are examining a list with 100 rows of data? In this case, you will want to use Excel's conditional formatting feature to build rules for marking only the cells outside your target range of values. For example, say you want to mark only those cells that have a value greater than 100 with an X. Follow these steps: • Select the range of data.

• On the Home tab, in the Styles group, click Conditional Formatting, then click Icon Sets. • Click 3 Symbols (Uncircled). • Click Conditional Formatting, then click Highlight Cell Rules Less Than. • In the Less Than dialog, enter 100. • Click the arrow in the With drop-down box and select Custom Format, then click OK twice. • Click Conditional Formatting, then click Manage Rules. • Click the Stop If True check box for the rule Cell Value = drop-down arrow of the first Value list and select.

• Create table rows and columns: Choose Insert→List to start the List Wizard, which helps you create row and column tables for your data. • File timesaver: Save your files as Excel Binary Workbook (.xlsb) to get a much smaller file that opens and saves faster. Excel for dummies mac.

• Click the Type drop-down arrow of the first Value list and select Number. • Click in the first Value text box and enter 100. • Click the Type drop-down arrow of the second Value list and select Number. • Click OK twice.