How to Use Conditional Formatting in Excel
Posted: Thu Jan 29, 2015 8:50 am
How to Use Conditional Formatting in Excel?
Conditional formatting is used to pick out important data from a huge list of data. Though it is a little difficult to use, knowing the basics can help us in whatever project we are working on.
We can use conditional formatting in many ways. Following are the two ways of using conditional formatting.
1 Conditional Formatting in Same Cell
2 Conditional Formatting in Multi Cell
3 Enter the number in the box provided for “Format cells that are GREATER THAN:”, and select ‘Custom Format’.
4 Select Fill from Format Cells, Select a required color from Background color and select OK.
5 The picture shows the result after applying Conditional Formatting
http://www.p2w2.com/expert-in-microsoft ... /index.php
Conditional formatting is used to pick out important data from a huge list of data. Though it is a little difficult to use, knowing the basics can help us in whatever project we are working on.
We can use conditional formatting in many ways. Following are the two ways of using conditional formatting.
1 Conditional Formatting in Same Cell
2 Conditional Formatting in Multi Cell
3 Enter the number in the box provided for “Format cells that are GREATER THAN:”, and select ‘Custom Format’.
4 Select Fill from Format Cells, Select a required color from Background color and select OK.
5 The picture shows the result after applying Conditional Formatting
http://www.p2w2.com/expert-in-microsoft ... /index.php