Computer Science, asked by reddysakesh05, 11 months ago

what is conditional formatting and write the steps to apply conditional formatting​

Answers

Answered by mouryarahul394
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 sukhmanbrar3
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:-

  1. select a range of cells on which conditional formatting is to be applied
  2. click the conditional formatting button in the styles group of the home tab. the conditional formatting dropdown menu appears.
  3. click the highlight cells rules option for highlighting the cells. a submenu appears. select the desired condition.
  4. a dialogue box appear. specified value in the textbook.
  5. click the dropdown arrow of with box and select the required formatting.
  6. click ok to apply conditional formatting. the cell will be highlighted according to the specific condition.

Mark as brainlist....

Similar questions