Search On Google

Monday, February 11, 2019

What is Conditional Formating in MS Excel

What is conditional Formatting?
With conditional formatting you can change data color or
Background color of data by checking condition of data.

Example:-

Suppose you want to set every data greater than 18 year age will be in red then
It will be in red color by using conditional formatting functionality of excel."

How to use Conditional formatting in excel?
Step:-Click on HOME tab.
Step2:-Click on conditional formatting.
Step3:-There are some pre-defined rules will be available you can select.
Step4:-In every rule you set criteria greater, less, equal etc.
Step5:- A popup will appear to set criteria as you wish.
Step6:-done

Note:-
 You can clear conditional formatting also by going there at same location from where you have applied.

Example:-
 In image you will see full step by step explanation below.


No comments:

Post a Comment

About Me

My photo
Mumbai, Maharashtra, India