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.
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