#3 Conditional Formatting in Excel

Learn and discuss Excel tips and techniques with Actuarial Info
Post Reply
User avatar
Mayank
Site Admin
Posts: 232
Joined: 06 Oct 2017, 11:19
Status: Offline

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
Actuarial Blogs Insurology

icon icon