Question

conditional formatting

Answer 1

select a2 through a7. then click home>conditional>formating. it is new rule

Answer 2

Answer:

Conditional formatting allows you to automatically apply formatting—such as colors, icons, and data bars—to one or more cells based on the cell value. To do this, you'll need to create a conditional formatting rule.