Scribd Logo
Upload

Welcome to Scribd!

  • 10 views

    Lab 7

    Uploaded by

    Kanishkar

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd

    Lab 7

    Uploaded by

    Kanishkar
    10 views15 pages

    Copyright

    © © All Rights Reserved

    Available Formats

    PPTX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    10 views15 pages

    Lab 7

    Uploaded by

    Kanishkar

    Copyright:

    © All Rights Reserved
    Download as PPTX, PDF, TXT or read online from Scribd
    Download as pptx, pdf, or txt
    You are on page 1of 15

    Live Virtual Class

    Topic : Conditional Formatting in Excel


    Faculty Name : Kusum Shewa
    Agenda
    Working with Conditional Formatting in Excel
    • What is Conditional Formatting
    • Highlight Cells Rules
    • Top / Bottom rules
    • Data bars
    • Color Scales
    • Icon Sets
    • New Rule
    • Clear Rules
    • Manage Rules
    Working with Conditional
    Formatting in Excel
    Conditional Formatting

    • Conditional formatting can help make patterns and trends in your data more
    apparent. To use it, you create rules that determine the format of cells based on
    their values. Following are few examples of using conditional formatting :
    Highlight Cell Rules

    • Highlight Cell Rules is a premade type of conditional formatting in Excel used to


    change the appearance of cells in a range based on your specified conditions.
    Top/Bottom Rules

    • Top/Bottom Rules are premade types of conditional formatting in Excel used to


    change the appearance of cells in a range based on specified conditions.
    Data Bars

    • Data Bars are premade types of conditional formatting in Excel used to add
    colored bars to cells in a range to indicate how large the cell values are compared
    to the other values.
    Colour Scales

    • Color Scales are premade types of conditional formatting in Excel used to highlight
    cells in a range to indicate how large the cell values are compared to the other
    values in the range.
    Icon Sets

    • Icon Sets are premade types of conditional formatting in Excel used to add icons to
    cells in a range to indicate how large the cell values are compared to the other
    values in the range.
    • Note: Icon Sets can be used together with other conditional formatting rules.
    5 min break

    • This a 5 min break for you


    • Have a glass of water
    • Take a deep breath
    • Note down any doubt you have till now
    • Join back

    DO NOT WRITE ANYTHING


    HERE. LEAVE THIS SPACE FOR
    WEBCAM
    New Rule

    • Excel allows users to define their own custom rules/conditions of conditional


    formatting to format the cells data. These new customized rules help the users to
    format and highlight the data according to them.
    Clear Rules

    • The Clear Rule option is used to clear all the Conditional Formatting from either
    Selected Range or entire sheet.
    Manage Rules

    • Conditional Formatting rules can be managed and removed using the Clear Rules
    and Manage Rules features.
    Any doubts?
    Summary

    Let’s Revise what we learnt today


    • What is Conditional Formatting
    • Highlight Cells Rules
    • Top / Bottom rules
    • Data bars
    • Color Scales
    • Icon Sets
    • New Rule
    DO NOT WRITE ANYTHING
    HERE. LEAVE THIS SPACE FOR
    • Clear Rules WEBCAM

    • Manage Rules

    You might also like