What are the different ways in which you can apply conditional formatting? Write the steps needed to perform conditional formatting using any one of the options.
Answers
Answer:
Explanation:
It is the feature available on Microsoft Excel to format one or more cells according to the conditions.
Using this feature we can apply the following formatting effects :-
Number format,text and dates
Font, font style and font colour
Border colour and style
Fill colour and pattern
To apply conditional formatting follow the following steps :-
Go to Home tab styles group.
Go to the option conditional formatting.
Click highlight cells rules.
Choose which type of condition you want such as greater than, less than, between, etc.
A dialog box appears.
In the Criterion box given specify the value or choose the cell address.
Select the formatting you want.
Choose ok.
The formatting will appear in your worksheet.
To remove it follow the steps below :-
Go to home tab styles group.
Select the option conditional formatting.
From the dropdown box select clear rules.
Choose the option accordingly as you want from clear rules from selected cells, clear rules from entire sheet, etc.