what is conditional formatting and write the steps to apply conditional formatting
Answers
Answered by
6
Answer:
first of all you have to selected the cell range that you want to give a condition and then go to conditional formatting options
Explanation:
Answered by
9
conditional formatting allows you to apply specific formats to a cell or a range of cells on the basis of the specified conditions or rules..
steps to apply conditional formatting are:-
- select a range of cells on which conditional formatting is to be applied
- click the conditional formatting button in the styles group of the home tab. the conditional formatting dropdown menu appears.
- click the highlight cells rules option for highlighting the cells. a submenu appears. select the desired condition.
- a dialogue box appear. specified value in the textbook.
- click the dropdown arrow of with box and select the required formatting.
- click ok to apply conditional formatting. the cell will be highlighted according to the specific condition.
Mark as brainlist....
Similar questions