microsoft excel training - Conditional formating

Hi Robert

Thank you for your question.

Yes, the conditional formatting in the 2007 version of Excel has been changed.

The main differences are that it has features called Data Bars, Colour Scales and Icon Sets which you can apply. What this does it that it automatically calculates in thirds (lowest third, middle third, highest third) and formats them according to what you've chosen. For example, Colour Scales would apply one colour to the lowest third, another to the middle third and another to the highest third. All in all, it's more of a comestic/visual effect than anything else.

The other change is that whereas before you could set more than one rule for an area of data that you had selected, in 2007 it seems you have to set rules one at a time.

I hope this helps to answer your question.
Amanda