Scribd
Upload
20 views10 pages

Conditional Formating Using Excel

Uploaded by

Ranjeet Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
20 views10 pages

Conditional Formating Using Excel

Uploaded by

Ranjeet Singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Conditional formatting

in excel
Muzaffar Ahunov
Conditional Formatting in Excel
Highlight values below average
Highlight duplicate values
Detecting cells with duplicate
observations
Highlight text that contains specific item you are looking
for
Formatting using your own
formulars
Extracting part of the text
Extracting part of the text
WilsonBob@[Link]=LEFT(D2,FIND(“@",D2)-1)

The result will be “WilsonBob”


Activity: Using titanic datasets
• Highlight all passengers below average age
• Change font color for passengers that deceased into red
• Highlight the names of all children 7 years and younger
• Create a column with last names for all passagners.
• Create a column that says “Below average” for people who paid ticket
price below average, for the rest of the passengers you need to write
“Above average”

You might also like