Question

what is conditional formatting in excel?​

Answer 1

Conditional formatting is a feature in Excel that allows we to set a cell's format according to the condition that you specify. For example- using conditional formatting, you can display number in a particular colour, depending on whether they are greater than, equal to, or less than certain value.

hope it will help you......

Answer 2

Answer:

• Create a custom conditional formatting rule
• Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
• On the Home tab, click Conditional Formatting.
• Click New Rule.
• Select a style, for example, 3-Color Scale, select the conditions that you want, and then click OK.