#3 Conditional Formatting in Excel

Learn and discuss Excel tips and techniques with Actuarial Info
Post Reply
User avatar
Site Admin
Posts: 197
Status: Offline

#3 Conditional Formatting in Excel

Post by Mayank » 25 Jan 2018, 15:56

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. 
Mayank Goyal
Post Reply