Best Offer for Books in Amazon

Showing posts with label How to work with conditional formatting in excel. Show all posts
Showing posts with label How to work with conditional formatting in excel. Show all posts

Tuesday 23 May 2017

Conditional formatting in Excel

How to work with conditional formatting in excel


Hi...Readers !

          In this lesson you can learn how to use conditional formatting in Excel data. This feature is most useful when we have more data if we want to highlight some specified cells in the database. "conditional formatting is nothing but highlighting data with different color formats and font styles for specified cells in entire database". 

Let us see create a small database like below 












1. Create a small database for employees and their salary details like above
2. home tab-> conditional formatting -> highlight cell rules -> equals to 
3. now you will see below settings 









4. type 'manager' in left input box
5. select 'light red fill' in right list menu.
6. click 'ok'
7. now in your database all your employees who are having manager designation will be highlighted with Red fill color. 

we can use this for other columns like salary, emp names or id nos also by using other conditions  like lessthan, greaterthan or equalsto ect...

thank you
excel trics blog

How to Protect sheet in Ms-Excel

STEPS:  1. OPEN Ms-Excel 2. Go to Review-> Protect Sheet -> Protect sheet  3. enter Password -> Re-enter Password-> save.