Chennai Laptop Service
Laptop Repair Service In Chennai
Call 8681030184 ; 8754598732
Conditional Formatting
WIIFM
Why is it important for us to know about „Conditional Formatting‟? :
-- So that it becomes easier to analyze information on a worksheet which may have a lot of data.
-- So that you can highlight the data in a manner that is easily comprehendible by the reader.
6.1. Conditional Formatting > Highlight Cells group
„Conditional Formatting‟ affects different cells differently based on the value contained within each cell using various rules. For example, if you wish to see the High, Average and low performers within a Sales Team, you will need to choose an appropriate rule to show the same on the sheet.
Let's discuss one of the rules to understand the concept of „Conditional Formatting‟.
Ø Highlight Cell Rules:
-- Create a new MS Excel workbook.
-- Enter the data as shown: