Conditional formatting in Excel has an Icon Set feature. Icon Sets have a variety of different icons. You can use icons, shapes, indicators, and direction arrows. This is great for visualizing the selected values by giving them different meanings to them.

In this video, I'll use two examples with monthly data and icons sets.

00:00 Introduction
00:18 Icon set example 1
01:15 Manage rules - use number
02:37 Show icon only
03:01 Icon set example 2
04:40 Closing remarks

Conditional Formatting videos by Chris Menard:
Excel Advanced Conditional Formatting
[ Ссылка ]
Excel Getting started with Conditional Formatting
[ Ссылка ]
Excel - Conditional Formatting find duplicates on two worksheets by Chris Menard
[ Ссылка ]

Screenshot on Icons Sets
[ Ссылка ]

And make sure you subscribe to my channel!

-- EQUIPMENT USED ---------------------------------
○ My camera – [ Ссылка ]
○ Microphone - [ Ссылка ]
○ Camera tripod – [ Ссылка ]
○ Studio lights - [ Ссылка ]
○ Dual monitor mount stand - [ Ссылка ]
○ Web camera – [ Ссылка ]
○ Shock mount - [ Ссылка ]
○ Boom Arm - [ Ссылка ]

-- SOFTWARE USED ---------------------------------
○ Screen recording – Camtasia – [ Ссылка ]
○ Screenshots – Snagit – [ Ссылка ]
○ YouTube keyword search – TubeBuddy – [ Ссылка ]

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!

свернуть