 | Working with 2, 3 or 4 Conditional Formats |  |
|
Added to Library on 06 May 2007
Length: 5 mins
View Tutorial Movie
Download File Used |
Excel's conditional formatting allows you to add up to 3 conditional statements. This tutorial uses a set of student marks to show you 4 important things;
1) How to use this feature
2) The order which these statements must be used
3) How to add a 4th statement (you will kick yourself when you see this one!)
4) How useful the Excel paintbrush is.
|
|
Related Tutorials:
Introduction to Conditional Formatting
|
Feedback for this tutorial:
"I love it! Thanks Clayton for showing me the process for the 4th conditional formatting addition. I couldn't see the forest through all the trees!! LOL Great tutorial. Kay Lenort"
"Really useful lesson, it will be of great use.
many thanks. "
"Loved the bit of tickery for the fourth condition . . . without this tutorial I wouldn't have discovered that possibility."
"I have just spent an afternoon juggling with amounts so as to only use three formats - when ideally I wanted four - and here is the answer !
So simple its brilliant !!"
|
|
|
| |
 | |  |
|
|
|
