1) Home/Styles/Conditonal Formatting
2) Pressing X on the Excel title bar closes workbooks one by one and then
when all workbooks are closed, closes Excel.
3) Suggest you get the cross reference from MS that shows you how to locate
Excel 2003 things in Excel 2007 - Also available for Word, PowerPoint,
Outlook.
Try searching for "office command reference" at MS

Tyro

"T. Valko" wrote in message
...
I finally broke down and installed Excel 2007...

The ribbon isn't horrible but it'll take some getting used to. Kind of
reminds me of a video game.

I've been looking around for about a half hour and I still haven't found
conditional formatting

On my 17" CRT monitor @ 100% zoom I get a whopping 18 rows by 11.6
columns work area!

I've already turned off formula autocomplete!

Some folks have complained about the contrast of selected cells - yeah, I
can see their point

I like the expandable formula bar - nice for those monster formulas

Here's something I don't understand...

If I want to close Excel I have to click the "X" twice? What's that all
about?

I can't wait to do some testing on calc times with formulas that use
entire columns as ranges!

I'm wondering if IFERROR makes a real difference with real long complex
formulas. My guess is that it isn't any better than a "crafted error trap"
although it would shorten some formulas considerably.



--
Biff
Microsoft Excel MVP