Computer Science, asked by sunilathounaojam794, 5 hours ago

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

Answered by akshat9910
1

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.

Similar questions