Content From: Excel Exposure
Conditional Formatting can be very useful when presenting data in a spreadsheet, or for allowing information to jump out to you easily.
In the following video lesson I go over the following uses of it:
– Formatting based on numerical values (greater than, less than, between, etc).
– Formatting based on text contained in cells.
– Quick overview of Data Bars, Color Scales, and Icon Sets
– How to use custom formulas with Conditional Formatting to highlight entire rows or other cells (extremely useful / versatile).
Make sure to download the most recent Master Workbook to follow along!
FYI, the formula at time 7:30 is =$H4=”Y”, it seems some people have trouble reading it.
Video Link: https://vimeo.com/41571682
Correction: The ‘Conditional Formatting’ option usually is located under the ‘Home’ tab and not the ‘View’ tab as referenced in the video. That is due to my custom group that I have on my home tab. To learn more about customizing your ribbon (aka the top menu area), see my Five Powerful Excel Tips video.