microsoft excel training - conditional formating

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Conditional formating

microsoft excel training - Conditional formating

resolvedResolved · Low Priority · Version Standard

Robert has attended:
Excel Intermediate course
Excel Advanced course

Conditional formating

I've heard that with the latest version of Excel the conditional formating section has been expanded and improved. What has been added and is this in practice very helpful?

RE: 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

RE: Conditional formating

I came across this:



which seems to be a pretty comprehensive summary of the new features.

RE: Conditional formating


 

Excel tip:

Concatenating Results of Formulas

To concatenate the results of formulas simply add the "&" after the formula or function closing bracket.

function1(....)&function2(.....)

see example Creating a range of monthly payments as text.

View all Excel hints and tips


Server loaded in 0.07 secs.