Excel - Manage conditional formatting Tutorial
In this video, you will learn how to manage conditional formatting in Microsoft 365. The video covers the rules manager, where you can create, edit, and delete formatting rules for specific areas of a workbook or worksheet.
It also explains how to manage the precedence of rules when conflicting rules apply to cells.
By changing the order of the rules, you can control how cells are formatted based on their values.
The video also demonstrates how to use conditional formatting to sort and filter a worksheet based on the applied formatting.
This will help you effectively utilize conditional formatting in Microsoft 365 and improve your data analysis and visualization.
- 4:30
- 4372 views
-
Excel - Use formulas to apply conditional formatting
- 4:20
- Viewed 4302 times
-
Excel - Use conditional formatting
- 2:02
- Viewed 3727 times
-
Excel - Copy and remove conditional formatting
- 1:11
- Viewed 3537 times
-
Excel - Conditionally format text
- 2:12
- Viewed 3630 times
-
Excel - Conditionally format dates
- 2:38
- Viewed 3917 times
-
Excel - Take conditional formatting to the next level
- 3:37
- Viewed 4036 times
-
Excel - Look up values on a different worksheet
- 2:39
- Viewed 4124 times
-
Excel - Copy a VLOOKUP formula
- 3:27
- Viewed 4271 times
-
Ink Equation
- 0:41
- Viewed 5365 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5164 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5060 times
-
3D Maps
- 1:41
- Viewed 4856 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4724 times
-
Start with "Ideas" in Excel
- 0:38
- Viewed 4544 times
-
Create a combo chart
- 1:47
- Viewed 4533 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4520 times
-
More complex formulas
- 4:17
- Viewed 4505 times
-
Create a PivotTable report manually
- 4:59
- Viewed 4416 times
-
Functions and formulas
- 3:24
- Viewed 4344 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4339 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4302 times
-
Start using Excel
- 4:22
- Viewed 4283 times
-
Manage drop-down lists
- 6:12
- Viewed 4271 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4271 times
-
New Chart types
- 1:52
- Viewed 4236 times
-
The SUMIF function
- 5:27
- Viewed 4236 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4200 times
-
A closer look at the ribbon
- 3:55
- Viewed 4197 times
-
The SUM function
- 4:37
- Viewed 4172 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4169 times
-
AVERAGEIF function
- 3:04
- Viewed 4162 times
-
Using functions
- 5:12
- Viewed 4125 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4124 times
-
Insert columns and rows
- 4:16
- Viewed 4099 times
-
Advanced formulas and references
- 4:06
- Viewed 4089 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 4077 times
-
A first look at Excel 2016
- 3:22
- Viewed 4075 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4068 times
-
Add numbers
- 2:54
- Viewed 4062 times
-
Top tips for working in Excel Online
- 3:35
- Viewed 4055 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 4055 times
-
Customize charts
- 4:28
- Viewed 4054 times
-
Work with macros
- 4:40
- Viewed 4048 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4039 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4036 times
-
Sort, filter, summarize and calculate your PivoteTable data
- 3:49
- Viewed 4028 times
-
Create a PivotTable and analyze your data
- 1:35
- Viewed 4015 times
-
Advanced filter details
- 4:13
- Viewed 3998 times
-
Subtract time
- 3:58
- Viewed 3994 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3988 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3984 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3974 times
-
Freeze panes in detail
- 3:30
- Viewed 3972 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3967 times
-
AutoFill
- 2:55
- Viewed 3958 times
-
More print options
- 5:59
- Viewed 3957 times
-
AutoFilter details
- 3:27
- Viewed 3954 times
-
How things are organized
- 1:58
- Viewed 3949 times
-
Copying formulas
- 3:00
- Viewed 3925 times
-
Input and error messages
- 2:52
- Viewed 3922 times
-
IF with AND and OR
- 3:35
- Viewed 3920 times
-
Conditionally format dates
- 2:38
- Viewed 3917 times
-
Introduction to Excel
- 0:59
- Viewed 3911 times
-
Assign a button to a macro
- 2:49
- Viewed 3893 times
-
Sort details
- 4:46
- Viewed 3891 times
-
Insert headers and footers
- 2:02
- Viewed 3884 times
-
Header and footer details
- 3:41
- Viewed 3881 times
-
Drop-down list settings
- 4:14
- Viewed 3879 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3872 times
-
How to create a table
- 2:11
- Viewed 3872 times
-
Chat with your co-editors in real-time
- 0:28
- Viewed 3871 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3839 times
-
Basic math
- 2:28
- Viewed 3804 times
-
Save your macro
- 2:59
- Viewed 3797 times
-
Operator order
- 2:04
- Viewed 3792 times
-
Weighted average
- 2:06
- Viewed 3773 times
-
Save and print an Excel workbook
- 1:53
- Viewed 3772 times
-
Advanced IF functions
- 3:22
- Viewed 3765 times
-
Cell references
- 1:34
- Viewed 3744 times
-
Copy a chart
- 2:59
- Viewed 3732 times
-
Use conditional formatting
- 2:02
- Viewed 3727 times
-
TEXTJOIN
- 0:47
- Viewed 3722 times
-
Improved version history
- 0:51
- Viewed 3721 times
-
Add formulas and references
- 2:52
- Viewed 3682 times
-
IFS
- 1:05
- Viewed 3645 times
-
Use slicers to filter data
- 1:25
- Viewed 3644 times
-
Save, publish, and share
- 2:22
- Viewed 3633 times
-
Map Chart in Excel
- 0:31
- Viewed 3632 times
-
Conditionally format text
- 2:12
- Viewed 3630 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3622 times
-
One click Forecasting
- 1:01
- Viewed 3618 times
-
Nested IF functions
- 3:30
- Viewed 3611 times
-
Get going fast
- 1:38
- Viewed 3586 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3537 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3522 times
-
Flash Fill
- 2:59
- Viewed 3499 times
-
CONCAT
- 0:51
- Viewed 3498 times
-
Freeze or lock panes
- 1:06
- Viewed 3482 times
-
Edit a macro
- 3:29
- Viewed 3471 times
-
Average a group of numbers
- 2:01
- Viewed 3456 times
-
Drop-down lists
- 0:55
- Viewed 3435 times
-
Create a chart
- 0:52
- Viewed 3420 times
-
Sort and filter data
- 1:38
- Viewed 3416 times
-
SWITCH
- 1:03
- Viewed 3396 times
-
Share documents
- 1:13
- Viewed 3317 times
-
Microsoft Search
- 0:34
- Viewed 3269 times
-
MAXIFS & MINIFS
- 1:06
- Viewed 3231 times
-
Work simultaneously with others on a workbook
- 0:43
- Viewed 3199 times
-
Translate your Excel spreadsheets
- 1:16
- Viewed 3185 times
-
Page numbers in depth
- 3:06
- Viewed 3125 times
-
Check Accessibility in Excel
- 1:51
- Viewed 3072 times
-
Funnel Chart
- 0:33
- Viewed 3051 times
-
Accessibility in Excel
- 1:12
- Viewed 2929 times
-
Use slicers, timelines and PivotCharts to analyze your pivotetable data
- 3:38
- Viewed 2766 times
-
XLOOKUP (Advanced metrics)
- 9:30
- Viewed 2729 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2603 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2577 times
-
Do things quickly with Tell Me
- 1:07
- Viewed 2530 times
-
Text before & after Function
- 4:57
- Viewed 2417 times
-
XLOOKUP (Basic metrics)
- 4:19
- Viewed 2398 times
-
Creating a forecast sheet with Excel
- 0:43
- Viewed 2307 times
-
Change chart type
- 1:29
- Viewed 2031 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1767 times
-
Use Copilot with Right-Click
- 02:50
- Viewed 1555 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1312 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1138 times
-
Format Data with Copilot
- 1:52
- Viewed 1111 times
-
Create an insights grid
- 01:19
- Viewed 461 times
-
Generate formulas from a concept
- 01:02
- Viewed 284 times
-
Use the Copilot pane
- 01:12
- Viewed 255 times
-
Process text
- 01:03
- Viewed 250 times
-
Remove a watermark
- 2:20
- Viewed 16803 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 5873 times
-
Align flow chart shapes and add connectors
- 4:48
- Viewed 5597 times
-
Change font size, line spacing, and indentation
- 5:09
- Viewed 5538 times
-
Ink Equation
- 0:41
- Viewed 5365 times
-
Convert handwritten texts or drawings with Powerpoint
- 0:33
- Viewed 5313 times
-
Change list formatting on the slide master
- 5:22
- Viewed 5208 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5164 times
-
Trigger text to play over a video
- 2:58
- Viewed 5146 times
-
Insert items in a presentation
- 2:38
- Viewed 5093 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5060 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 4875 times
-
3D Maps
- 1:41
- Viewed 4856 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 4791 times
-
Print Notes Pages as handouts
- 3:15
- Viewed 4750 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4724 times
-
Add headers and footers to slides
- 3:52
- Viewed 4666 times
-
Add a sound effect to a transition
- 3:45
- Viewed 4636 times
-
Finalize and review a presentation
- 2:02
- Viewed 4579 times
-
Add sound effects to an animation
- 4:29
- Viewed 4542 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 4537 times
-
Create a combo chart
- 1:47
- Viewed 4533 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4520 times
-
More complex formulas
- 4:17
- Viewed 4505 times
-
Create a new slide master and layouts
- 5:13
- Viewed 4388 times
-
Animate charts and SmartArt
- 3:36
- Viewed 4383 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4361 times
-
Functions and formulas
- 3:24
- Viewed 4344 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4339 times
-
Customize the slide master
- 4:38
- Viewed 4320 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4302 times
-
Trigger an animation effect
- 2:29
- Viewed 4298 times
-
Work with a motion path
- 2:50
- Viewed 4296 times
-
Start using Excel
- 4:22
- Viewed 4283 times
-
Build an org chart using the text pane
- 4:00
- Viewed 4282 times
-
Manage drop-down lists
- 6:12
- Viewed 4271 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4271 times
-
Prepare a basic handout
- 4:30
- Viewed 4264 times
-
Create a flow chart
- 3:27
- Viewed 4249 times
-
New Chart types
- 1:52
- Viewed 4236 times
-
The SUMIF function
- 5:27
- Viewed 4236 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 4232 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4200 times
-
Create slide content and save the template
- 4:50
- Viewed 4194 times
-
The SUM function
- 4:37
- Viewed 4172 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4169 times
-
AVERAGEIF function
- 3:04
- Viewed 4162 times
-
Using functions
- 5:12
- Viewed 4125 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4124 times
-
Insert columns and rows
- 4:16
- Viewed 4099 times
-
Advanced formulas and references
- 4:06
- Viewed 4089 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 4077 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4068 times
-
Add numbers
- 2:54
- Viewed 4062 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 4055 times
-
Animate pictures, shapes, text, and other objects
- 4:02
- Viewed 4055 times
-
Customize charts
- 4:28
- Viewed 4054 times
-
Work with macros
- 4:40
- Viewed 4048 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4039 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4036 times
-
Create slicers
- 3:55
- Viewed 4029 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 4028 times
-
Create quick measures
- 3:02
- Viewed 4010 times
-
Customize colors and save the theme
- 4:45
- Viewed 4004 times
-
Advanced filter details
- 4:13
- Viewed 3998 times
-
Use slide masters to customize a presentation
- 3:07
- Viewed 3997 times
-
Subtract time
- 3:58
- Viewed 3994 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3988 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3984 times
-
Add a picture watermark
- 4:36
- Viewed 3978 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3974 times
-
Customize the design and layouts
- 5:06
- Viewed 3973 times
-
Freeze panes in detail
- 3:30
- Viewed 3972 times
-
Create a template from a presentation
- 3:09
- Viewed 3968 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3967 times
-
More print options
- 5:59
- Viewed 3957 times
-
AutoFilter details
- 3:27
- Viewed 3954 times
-
Backgrounds in PowerPoint: First Steps
- 3:20
- Viewed 3954 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 3945 times
-
Print slides, notes, or handouts
- 2:48
- Viewed 3932 times
-
Copying formulas
- 3:00
- Viewed 3925 times
-
Input and error messages
- 2:52
- Viewed 3922 times
-
IF with AND and OR
- 3:35
- Viewed 3920 times
-
Conditionally format dates
- 2:38
- Viewed 3917 times
-
Create custom animations with motion paths
- 3:39
- Viewed 3906 times
-
Assign a button to a macro
- 2:49
- Viewed 3893 times
-
Sort details
- 4:46
- Viewed 3891 times
-
Insert headers and footers
- 2:02
- Viewed 3884 times
-
Header and footer details
- 3:41
- Viewed 3881 times
-
Drop-down list settings
- 4:14
- Viewed 3879 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3872 times
-
How to create a table
- 2:11
- Viewed 3872 times
-
Work with handout masters
- 4:34
- Viewed 3861 times
-
Change the theme background
- 5:38
- Viewed 3859 times
-
Animate pictures and shapes
- 4:17
- Viewed 3849 times
-
Picture backgrounds: Two methods
- 4:58
- Viewed 3840 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3839 times
-
Creating and managing a group
- 1:56
- Viewed 3824 times
-
Print handouts
- 4:32
- Viewed 3809 times
-
Basic math
- 2:28
- Viewed 3804 times
-
Screen recording
- 0:49
- Viewed 3798 times
-
Save your macro
- 2:59
- Viewed 3797 times
-
Operator order
- 2:04
- Viewed 3792 times
-
Weighted average
- 2:06
- Viewed 3773 times
-
Advanced IF functions
- 3:22
- Viewed 3765 times
-
Cell references
- 1:34
- Viewed 3744 times
-
Copy a chart
- 2:59
- Viewed 3732 times
-
Use conditional formatting
- 2:02
- Viewed 3727 times
-
Improved version history
- 0:51
- Viewed 3721 times
-
Customize master layouts
- 4:57
- Viewed 3721 times
-
Apply and change a theme
- 5:13
- Viewed 3683 times
-
Add formulas and references
- 2:52
- Viewed 3682 times
-
Use slicers to filter data
- 1:25
- Viewed 3644 times
-
Conditionally format text
- 2:12
- Viewed 3630 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3622 times
-
Prepare and run your presentation
- 1:28
- Viewed 3621 times
-
One click Forecasting
- 1:01
- Viewed 3618 times
-
Nested IF functions
- 3:30
- Viewed 3611 times
-
Removing backgrounds in PowerPoint
- 2:45
- Viewed 3600 times
-
Combine a path with other effects
- 4:49
- Viewed 3597 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3590 times
-
Add headers and footers to a presentation
- 2:50
- Viewed 3584 times
-
90 seconds about PowerPoint Slide Masters
- 1:17
- Viewed 3581 times
-
Summarize Your Notes with Copilot
- 1:45
- Viewed 3543 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3537 times
-
Create an org chart
- 3:09
- Viewed 3527 times
-
Conditional formatting
- 3:35
- Viewed 3526 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3522 times
-
Use the drill down filter
- 4:41
- Viewed 3517 times
-
Edit headers and footers for handouts
- 2:43
- Viewed 3485 times
-
Freeze or lock panes
- 1:06
- Viewed 3482 times
-
Edit a macro
- 3:29
- Viewed 3471 times
-
New chart types
- 0:39
- Viewed 3470 times
-
Build an org chart using SmartArt Tools
- 5:09
- Viewed 3470 times
-
Ink Equation
- 0:40
- Viewed 3458 times
-
Animate text
- 4:14
- Viewed 3457 times
-
Average a group of numbers
- 2:01
- Viewed 3456 times
-
Add staff members
- 2:57
- Viewed 3456 times
-
Design motion paths
- 2:30
- Viewed 3450 times
-
Drop-down lists
- 0:55
- Viewed 3435 times
-
Sort and filter data
- 1:38
- Viewed 3416 times
-
Apply paths to layered pictures
- 5:28
- Viewed 3414 times
-
Calculate function
- 4:22
- Viewed 3394 times
-
Present Live
- 3:13
- Viewed 3375 times
-
Create a sequence with line paths
- 6:42
- Viewed 3344 times
-
Make a reservation [Staff]
- 1:55
- Viewed 3253 times
-
Start using PowerPoint
- 2:06
- Viewed 3249 times
-
Add bullets to text
- 2:24
- Viewed 3217 times
-
Create a new calendar
- 2:55
- Viewed 3209 times
-
Turn on the drill down feature
- 2:23
- Viewed 3195 times
-
Trigger a video
- 4:06
- Viewed 3191 times
-
Add an alert to a visual
- 2:24
- Viewed 3113 times
-
Integrate Bookings into TEAMS
- 1:36
- Viewed 3076 times
-
Turn your Excel tables into real lists!
- 1:12
- Viewed 3073 times
-
Manage interactions
- 1:56
- Viewed 3067 times
-
Make a reservation [Customer]
- 2:13
- Viewed 3043 times
-
Add a Table from Text with Copilot
- 1:39
- Viewed 3039 times
-
Create custom fields
- 1:21
- Viewed 3027 times
-
Manage relations between data sources
- 2:37
- Viewed 2988 times
-
Complete and Share a Schedule
- 2:02
- Viewed 2974 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 2913 times
-
What are measures?
- 2:58
- Viewed 2906 times
-
Organise notes
- 2:57
- Viewed 2903 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2888 times
-
Add a service
- 2:03
- Viewed 2886 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2867 times
-
Research in your notes
- 1:13
- Viewed 2866 times
-
Create a Schedule and Organise it with the Help of Groups
- 1:42
- Viewed 2857 times
-
Use template to prepare your Agile SCRUM meeting
- 2:50
- Viewed 2849 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2811 times
-
Create and organise a group
- 1:30
- Viewed 2807 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2801 times
-
Draw, sketch or handwrite notes
- 1:25
- Viewed 2798 times
-
Send your notes by email
- 0:42
- Viewed 2750 times
-
How Clock In Works
- 0:22
- Viewed 2716 times
-
Add a Visio diagram
- 1:23
- Viewed 2688 times
-
Manage our recent documents
- 2:24
- Viewed 2649 times
-
Make better tables
- 10 min
- Viewed 2647 times
-
Creating and managing campaigns
- 1:39
- Viewed 2626 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2618 times
-
Password protect your notes
- 1:43
- Viewed 2607 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2603 times
-
Create a new shared booking page
- 2:32
- Viewed 2603 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2577 times
-
Save, share and share everything
- 0:49
- Viewed 2537 times
-
Creating or editing office documents in Engage
- 0:44
- Viewed 2428 times
-
Add an Excel spreadsheet
- 1:31
- Viewed 2426 times
-
Insert online videos
- 0:41
- Viewed 2421 times
-
Text before & after Function
- 4:57
- Viewed 2417 times
-
Imbrication OneNote / Teams
- 1:03
- Viewed 2395 times
-
Summarize the Content of a Note with Copilot
- 1:03
- Viewed 2394 times
-
Rewrite or Summarize Existing Text with Copilot
- 2:29
- Viewed 2380 times
-
Add files
- 1:26
- Viewed 2366 times
-
See who's collaborating
- 2:01
- Viewed 2357 times
-
Add items
- 2:04
- Viewed 2354 times
-
Meeting recordings in Microsoft Teams
- 1:13
- Viewed 2347 times
-
Make a reservation Employee]
- 1:50
- Viewed 2327 times
-
Create a video from the web app
- 1:20
- Viewed 2320 times
-
Use page templates
- 2:19
- Viewed 2312 times
-
Upload an existing video from your device
- 1:11
- Viewed 2301 times
-
Imbrication OneNote / Outlook
- 1:37
- Viewed 2299 times
-
How to Copy a Schedule
- 0:39
- Viewed 2299 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 2289 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 2279 times
-
Sync and sharing
- 0:28
- Viewed 2270 times
-
Add staff
- 2:36
- Viewed 2267 times
-
Create custom fields
- 1:12
- Viewed 2241 times
-
Record a live PowerPoint presentation
- 1:18
- Viewed 2220 times
-
Install Office on 5 devices
- 1:53
- Viewed 2218 times
-
Create a video from the mobile app
- 1:13
- Viewed 2200 times
-
Add or edit a thumbnail
- 0:59
- Viewed 2170 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 2163 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 2156 times
-
Engaging and animating a group
- 1:55
- Viewed 2040 times
-
Change chart type
- 1:29
- Viewed 2031 times
-
Make a reservation [Customer]
- 1:51
- Viewed 1915 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1892 times
-
Generate a Chart with Copilot
- 1:34
- Viewed 1767 times
-
Create a Task List or Plan with Copilot
- 1:49
- Viewed 1757 times
-
Add a service
- 2:28
- Viewed 1692 times
-
Create a Presentation with Copilot
- 1:50
- Viewed 1684 times
-
Save a PowerPoint presentation
- 1:10
- Viewed 1672 times
-
Draft Content Based on an Existing Document with Copilot
- 2:15
- Viewed 1589 times
-
Create a Presentation Based on an Existing Word Document
- 1:52
- Viewed 1566 times
-
Draft an Email with Copilot
- 02:36
- Viewed 1423 times
-
Sort, Filter, and Analyze Data with Copilot
- 1:48
- Viewed 1312 times
-
Summarize a Slideshow with Copilot
- 1:34
- Viewed 1161 times
-
Generate Formulas with Copilot
- 2:07
- Viewed 1138 times
-
Format Data with Copilot
- 1:52
- Viewed 1111 times
-
Improve Email Writing with Copilot Coaching
- 01:47
- Viewed 1107 times
-
Energize and Structure a Presentation with Copilot
- 1:50
- Viewed 1069 times
-
Analyze and Write Content Based on a File
- 2:16
- Viewed 1058 times
-
Generate Text from an Idea or Plan
- 2:51
- Viewed 998 times
-
Generating Loop Content with Copilot
- 01:18
- Viewed 577 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 534 times
-
Create a reminder for yourself
- 01:59
- Viewed 507 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 506 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 447 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 437 times
-
Summarizing a Loop Page with Copilot
- 00:55
- Viewed 436 times
-
Create and add a signature to messages
- 01:26
- Viewed 416 times
-
Create different types of events
- 01:46
- Viewed 398 times
-
Make changes to a text
- 01:05
- Viewed 393 times
-
Edit and customize views
- 01:55
- Viewed 379 times
-
Sort and filter emails
- 02:51
- Viewed 374 times
-
Manage Teams online meeting options
- 01:56
- Viewed 359 times
-
Create an Email Template
- 01:40
- Viewed 359 times
-
Save and Print a Message
- 01:48
- Viewed 353 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 353 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 349 times
-
Change the default font of your emails
- 01:05
- Viewed 348 times
-
Delay Email Delivery
- 01:10
- Viewed 329 times
-
Improve Email Accessibility
- 02:02
- Viewed 325 times
-
Search options
- 01:23
- Viewed 318 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 318 times
-
Translate Emails in Outlook
- 01:32
- Viewed 314 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 309 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 305 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 284 times
-
Generate formulas from a concept
- 01:02
- Viewed 284 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 261 times
-
Is a hacker always a cybercriminal?
- 01:31
- Viewed 10 times
-
Will I know what to do if I get hacked?
- 01:16
- Viewed 7 times
-
Do I have to be an IT expert to protect myself?
- 01:14
- Viewed 9 times
-
Do cybercriminals only target large companies?
- 01:21
- Viewed 8 times
-
Are all files safe as long as I open them with trusted software?
- 01:24
- Viewed 9 times
-
Is contactless payment safe ?
- 01:26
- Viewed 9 times
-
Are online payments riskier than in-store ones?
- 01:21
- Viewed 8 times
-
Is cloud storage less secure than my personal computer?
- 01:37
- Viewed 8 times
-
Is scanning a QR code always safe?
- 01:21
- Viewed 7 times
-
Can my mobile apps do anything without my permission?
- 01:19
- Viewed 8 times
-
Is public Wi-Fi safe if no password is required?
- 01:26
- Viewed 7 times
-
Is the sender’s email address enough to verify a message?
- 01:29
- Viewed 7 times
-
Can I safely click a link in a message?
- 01:46
- Viewed 8 times
-
Does connecting to a well-known website guarantee its safety?
- 01:27
- Viewed 8 times
-
Am I safe online if I’m careful?
- 01:22
- Viewed 8 times
-
Does private browsing make me anonymous?
- 01:27
- Viewed 9 times
-
Are updates useless if everything works fine?
- 01:28
- Viewed 6 times
-
Is a firewall the same as an antivirus?
- 01:31
- Viewed 6 times
-
Does my antivirus block all threats?
- 01:46
- Viewed 7 times
-
Is a free antivirus good enough?
- 01:38
- Viewed 9 times
-
Is signing in with Google or Facebook a bad idea ?
- 01:34
- Viewed 6 times
-
Is my password secure if it contains an @ and a number?
- 01:41
- Viewed 9 times
-
Is a strong password all I need to stay safe?
- 01:55
- Viewed 8 times
-
Unlock new possibilities with the Mistral Canvas
- 02:01
- Viewed 11 times
-
Mistral at the service of coding
- 01:37
- Viewed 11 times
-
Analyze and compare your documents with Mistral
- 01:58
- Viewed 10 times
-
Generate your images and visuals with Mistral AI
- 02:06
- Viewed 10 times
-
Use Mistral AI to summarize online information
- 01:00
- Viewed 9 times
-
Exchange and manage your conversations with Mistral AI
- 03:31
- Viewed 10 times
-
Explore Mistral AI's generative options
- 01:51
- Viewed 10 times
-
Set up your Mistral workspace
- 01:42
- Viewed 9 times
-
Discover Mistral, the French-style AI
- 01:51
- Viewed 10 times
-
Instant alerts tailored to your activities
- 01:53
- Viewed 27 times
-
Seamless collaboration inside Microsoft Teams
- 01:22
- Viewed 23 times
-
Easy sharing with your team or organization
- 01:12
- Viewed 24 times
-
Relevant views to highlight your information
- 01:52
- Viewed 32 times
-
Clear insights through filters and sorting
- 02:06
- Viewed 22 times
-
A well-structured form for easy entry
- 01:17
- Viewed 27 times
-
The right column type for each data set
- 02:35
- Viewed 23 times
-
Custom columns to match your needs
- 02:09
- Viewed 23 times
-
Smooth updates and management for any list
- 01:06
- Viewed 24 times
-
Simple ways to add data to your list
- 01:06
- Viewed 25 times
-
Excel data turned into a dynamic list
- 02:08
- Viewed 25 times
-
A fully custom list built from scratch
- 01:34
- Viewed 26 times
-
A quick setup with ready-made templates
- 01:34
- Viewed 28 times
-
Mobile access to your lists made simple
- 01:37
- Viewed 32 times
-
The essentials of the Lists interface
- 02:01
- Viewed 25 times
-
The key reasons to use Microsoft Lists
- 02:01
- Viewed 28 times
-
Personality and tone for a believable rendering
- 01:48
- Viewed 65 times
-
Format and example for optimal results
- 02:03
- Viewed 67 times
-
The Importance of Context in Your Applications
- 02:14
- Viewed 58 times
-
Task Accuracy in Prompting
- 02:31
- Viewed 126 times
-
The Basis of Prompting in Conversational AI
- 02:41
- Viewed 55 times
-
What is a prompt in conversational AI?
- 02:02
- Viewed 62 times
-
Extract Text from an Image
- 01:07
- Viewed 82 times
-
Reply to an Email with Copilot
- 01:10
- Viewed 140 times
-
Create SharePoint Pages with Copilot
- 01:49
- Viewed 153 times
-
Query an Attached Meeting
- 01:51
- Viewed 65 times
-
Plan with Copilot
- 01:15
- Viewed 96 times
-
Share Requests with Your Team
- 03:07
- Viewed 144 times
-
Translate a presentation
- 01:38
- Viewed 73 times
-
Generate a Video
- 01:49
- Viewed 79 times
-
Add Speaker Notes
- 00:56
- Viewed 81 times
-
Initiate a project budget tracking table with Copilot
- 02:54
- Viewed 148 times
-
Develop and share a clear project follow-up with Copilot
- 02:18
- Viewed 136 times
-
Organize an action plan with Copilot and Microsoft Planner
- 01:31
- Viewed 156 times
-
Structure and optimize team collaboration with Copilot
- 02:28
- Viewed 197 times
-
Copilot at the service of project reports
- 02:36
- Viewed 165 times
-
Initiate a tracking table with ChatGPT
- 01:35
- Viewed 169 times
-
Distribute tasks within a team with ChatGPT
- 01:26
- Viewed 304 times
-
Generate a meeting summary with ChatGPT
- 01:24
- Viewed 169 times
-
Project mode
- 01:31
- Viewed 163 times
-
Create an agent for a team
- 01:53
- Viewed 278 times
-
Install and access Copilot Studio in Teams
- 01:38
- Viewed 276 times
-
Analyze the Copilot Studio agent
- 01:25
- Viewed 131 times
-
Publish the agent and make it accessible
- 01:39
- Viewed 280 times
-
Copilot Studio agent settings
- 01:33
- Viewed 120 times
-
Add new actions
- 01:54
- Viewed 278 times
-
Create a first action
- 01:59
- Viewed 266 times
-
Manage topics
- 01:51
- Viewed 152 times
-
Manage knowledge sources
- 01:11
- Viewed 117 times
-
Create an agent with Copilot Studio
- 01:52
- Viewed 268 times
-
Access Copilot Studio
- 01:09
- Viewed 264 times
-
Get started with Copilot Studio
- 01:25
- Viewed 130 times
-
Introduction to PowerBI
- 00:60
- Viewed 293 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 279 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 271 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 304 times
-
Introduction to Planner
- 00:56
- Viewed 282 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 420 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 288 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 427 times
-
Introduction to Sway
- 01:53
- Viewed 365 times
-
Introducing to Word
- 01:00
- Viewed 268 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 257 times
-
Create a call group
- 01:15
- Viewed 456 times
-
Use call delegation
- 01:07
- Viewed 223 times
-
Assign a delegate for your calls
- 01:08
- Viewed 424 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 229 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 228 times
-
Manage advanced call notifications
- 01:29
- Viewed 240 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 377 times
-
Block unwanted calls
- 01:24
- Viewed 273 times
-
Disable all call forwarding
- 01:09
- Viewed 252 times
-
Manage a call group in Teams
- 02:01
- Viewed 271 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 224 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 228 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 245 times
-
Manage voicemail messages
- 01:55
- Viewed 381 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 417 times
-
Customize your voicemail greeting
- 02:17
- Viewed 224 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 288 times
-
Manage simultaneous calls
- 01:52
- Viewed 255 times
-
Support third-party apps during calls
- 01:53
- Viewed 364 times
-
Add participants quickly and securely
- 01:37
- Viewed 241 times
-
Configure call privacy and security settings
- 02:51
- Viewed 239 times
-
Manage calls on hold
- 01:20
- Viewed 235 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 243 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 232 times
-
Draft a Service Memo
- 02:33
- Viewed 278 times
-
Extract Invoice Data and Generate a Pivot Table
- 03:26
- Viewed 266 times
-
Formulate a Request for Pricing Conditions via Email
- 02:32
- Viewed 436 times
-
Analyze a Supply Catalog Based on Needs and Budget
- 02:41
- Viewed 408 times
-
SharePoint Page Co-Editing: Collaborate in Real Time
- 02:14
- Viewed 140 times
-
Other Coaches
- 01:45
- Viewed 292 times
-
Agents in SharePoint
- 02:44
- Viewed 233 times
-
Prompt coach
- 02:49
- Viewed 260 times
-
Modify, Share, and Install an Agent
- 01:43
- Viewed 246 times
-
Configure a Copilot Agent
- 02:39
- Viewed 256 times
-
Describe a copilot agent
- 01:32
- Viewed 292 times
-
Rewrite with Copilot
- 01:21
- Viewed 245 times
-
Analyze a video
- 01:21
- Viewed 267 times
-
Use the Copilot pane
- 01:12
- Viewed 255 times
-
Process text
- 01:03
- Viewed 250 times
-
Create an insights grid
- 01:19
- Viewed 461 times
-
Generate and manipulate an image in PowerPoint
- 01:47
- Viewed 255 times
-
Interact with a web page with Copilot
- 00:36
- Viewed 275 times
-
Create an image with Copilot
- 00:42
- Viewed 472 times
-
Summarize a PDF with Copilot
- 00:41
- Viewed 267 times
-
Analyze your documents with Copilot
- 01:15
- Viewed 272 times
-
Chat with Copilot
- 00:50
- Viewed 281 times
-
Particularities of Personal and Professional Copilot Accounts
- 00:40
- Viewed 453 times
-
Data Privacy in Copilot
- 00:43
- Viewed 275 times
-
Access Copilot
- 00:25
- Viewed 486 times
-
Use a Copilot Agent
- 01:24
- Viewed 311 times
-
Edit in Pages
- 01:49
- Viewed 319 times
-
Generate and manipulate an image in Word
- 01:19
- Viewed 292 times
-
Create Outlook rules with Copilot
- 01:12
- Viewed 278 times
-
Generate the email for the recipient
- 00:44
- Viewed 268 times
-
Action Function
- 04:18
- Viewed 237 times
-
Search Function
- 03:42
- Viewed 280 times
-
Date and Time Function
- 02:53
- Viewed 300 times
-
Logical Function
- 03:14
- Viewed 461 times
-
Text Function
- 03:25
- Viewed 292 times
-
Basic Function
- 02:35
- Viewed 249 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 291 times
-
Introduction to Power Fx
- 01:09
- Viewed 295 times
-
The New Calendar
- 03:14
- Viewed 499 times
-
Sections
- 02:34
- Viewed 262 times
-
Customizing Views
- 03:25
- Viewed 253 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 560 times
Objectifs :
This document aims to provide a comprehensive understanding of managing conditional formatting rules in Excel, including how to create, edit, delete, and prioritize these rules effectively. It also covers how to identify cells with conditional formatting and how to sort and filter data based on these formatting rules.
Chapitres :
-
Introduction to Conditional Formatting
Conditional formatting in Excel allows users to apply specific formatting to cells based on their values. This feature enhances data visualization and helps in identifying trends and patterns quickly. -
Accessing the Conditional Formatting Rules Manager
To manage conditional formatting rules, navigate to the Conditional Formatting Rules Manager. Here, you can choose to display formatting rules for specific areas of a workbook or a particular worksheet. This interface allows you to create, edit, delete rules, and manage their precedence. -
Understanding Rule Precedence
When multiple rules apply to the same cell, the rule with higher precedence takes effect. By default, the most recently created rule is positioned at the top of the list, thus having precedence over earlier rules. For instance, if you have two rules: one for values greater than 60,000 and another for values greater than 70,000, the latter will format the cell with a blue fill if the value exceeds 70,000. -
Example of Rule Application
In the example provided, cells B2 through B10 have two rules applied. The first rule formats cells with a blue fill for values greater than 60,000, while the second rule applies to values greater than 70,000. Since the value in cell B2 is 70,000, it is formatted with blue fill due to the precedence of the 70,000 rule. -
Changing Rule Order
If you change the order of the rules, the formatting will also change. For example, if the rule for values greater than 60,000 is moved above the 70,000 rule, cells with values between 60,000 and 70,000 will be formatted with a yellow fill instead of blue. -
Identifying Cells with Conditional Formatting
To identify which cells in a worksheet have conditional formatting rules, use the 'Find and Select' button on the Home tab. This feature allows you to select all cells that contain conditional formatting, making it easier to review and manage these rules. -
Sorting and Filtering Based on Conditional Formatting
You can also sort and filter data based on the colors applied through conditional formatting. To sort, select the desired cells, click the 'Sort and Filter' button on the Home tab, and choose 'Custom Sort.' For filtering, select the cells, click 'Filter,' and then use the filter down arrow to filter by color, allowing you to display only the rows with specific formatting. -
Conclusion
Understanding and effectively managing conditional formatting in Excel can significantly enhance data analysis and presentation. By mastering these techniques, users can better visualize their data and make informed decisions based on the insights gained from conditional formatting.
FAQ :
What is conditional formatting in spreadsheets?
Conditional formatting is a feature that allows users to apply specific formatting styles to cells based on the values or conditions they meet, making it easier to visualize data.
How do I access the rules manager for conditional formatting?
You can access the rules manager by selecting the 'Conditional Formatting' option in the Home tab of your spreadsheet application, where you can create, edit, and manage your formatting rules.
What happens when multiple conditional formatting rules apply to the same cell?
When multiple rules apply to the same cell, the rule with the highest precedence is applied. By default, the most recently created rule has the highest precedence.
Can I sort data based on conditional formatting?
Yes, you can sort data based on conditional formatting by selecting the cells you want to sort and using the 'Sort and Filter' options in the Home tab to organize them according to the formatting applied.
How can I filter rows based on conditional formatting?
To filter rows based on conditional formatting, select the cells you want to filter, click on 'Sort and Filter', then choose 'Filter', and use the filter down arrow to select 'Filter by Color' for the desired formatting.
Quelques cas d'usages :
Sales Performance Analysis
In a sales report, conditional formatting can be used to highlight sales figures that exceed targets. For example, cells with sales over $70,000 can be filled with blue, while those between $60,000 and $70,000 can be filled with yellow. This visual differentiation helps managers quickly identify high-performing sales representatives.
Error Tracking in Financial Reports
Conditional formatting can be applied to highlight cells that contain errors or blank values in financial reports. By using red fill for errors and yellow for blanks, analysts can easily spot and address issues in the data, ensuring accuracy in reporting.
Project Management Dashboard
In a project management dashboard, conditional formatting can be used to indicate the status of tasks. For instance, tasks that are overdue can be highlighted in red, while those that are on track can be green. This allows project managers to quickly assess project health and prioritize tasks.
Inventory Management
Conditional formatting can help in inventory management by highlighting low stock items in red. This visual cue alerts managers to reorder products before they run out, improving inventory control and reducing stockouts.
Customer Feedback Analysis
In analyzing customer feedback, conditional formatting can be used to categorize feedback scores. For example, scores above 4 can be highlighted in green, while scores below 2 can be red. This helps teams focus on areas needing improvement and recognize high satisfaction levels.
Glossaire :
Conditional Formatting
A feature in spreadsheet applications that allows users to apply specific formatting to cells based on certain conditions or criteria.
Rules Manager
A tool within conditional formatting that allows users to create, edit, delete, and manage the precedence of formatting rules applied to cells.
Precedence
The order of importance assigned to conditional formatting rules; the rule with higher precedence is applied first when multiple rules conflict.
Fill Color
The background color applied to a cell in a spreadsheet, which can be changed based on conditional formatting rules.
Sort and Filter
Functions in spreadsheet applications that allow users to organize data in a specific order or to display only certain data based on criteria.
Custom Sort
A sorting option that allows users to define specific criteria for how data should be ordered, such as sorting by color or icon.
Data Tab
A section in spreadsheet applications that contains tools for managing and analyzing data, including sorting and filtering options.
Filter by Color
A filtering option that allows users to display only the rows in a worksheet that contain cells formatted with a specific color.
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise