Question

Raj, a data entering operator of a company must store the earning and all expenses data in a worksheet. He has to indicate the data by different colors. What feature of excel will help him to change the color of the cells of columns depending upon the earnings and expenses? Explain the feature in brief.​

Answer 1

Explanation:

Select the cell values, and click Home > Conditional Formatting > New Rule. 3. Click Format to go to Format Cells dialog, then under the Font tab, select one color you want from the Color list. Then click OK > OK to close dialogs.