Question

Write the process to apply conditional formatting in the selected cells whose name starts with "a".​

Answer 1

Answer:

Apply conditional formatting to text

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.

Point to Highlight Cells Rules, and then click Text that Contains.

Type the text that you want to highlight, and then click OK.