Loading...

Highline Excel Class 21: Conditional Formatting 12 Examples

108,524 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on May 18, 2009

Download Excel file: http://people.highline.edu/mgirvin/ex...

See how to add conditional formatting for:
1)Data Bars to show relative size
2)Icons to show relative size
3)Highlight values within 1 standard deviation
4)Highlight MIN in column with a TRUE FALSE formula
5)Highlight MAX in column with a TRUE FALSE formula
6)Highlight two largest values with a TRUE FALSE formula
7)Highlight a of values with a TRUE FALSE formula
8)Highlight a column of values with a TRUE FALSE formula
9)Highlight an intersection with a TRUE FALSE formula
10)Learn about Stop If True
11)Learn about the order of the TRUE FALSE formulas
12)Apply more than 1 conditional formatting
This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...