248,680 views
25 votes
25 votes
You would use conditional formatting on a cell when you want to _____

User Tianran Shen
by
2.9k points

1 Answer

15 votes
15 votes

Answer:

to format a cell based on the value in it

Step-by-step explanation:

you would use conditional formatting on a cell when you want to format a cell based on the value in it.

Reason -

Conditional formatting allows you to format a cell based on the value in it.

For example, if you want to highlight all the cells where the value is less than 30 with a red color, you can do that with conditional formatting.

  • How would you highlight cells with negative values in it?

You can use conditional formatting.

User The Dumb Radish
by
3.1k points