How to Use Conditional Formatting in Excel

Advertisements, add-ons and other commercial information
Post Reply
krishnap2w2
Posts: 1
Joined: Tue Dec 23, 2014 12:24 pm
OLAP Product: Oracle
Version: 10.1
Excel Version: 2010

How to Use Conditional Formatting in Excel

Post by krishnap2w2 » 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
Attachments
How to Use Conditional Formatting in Excel.pdf
(753.67 KiB) Downloaded 173 times

Post Reply