you decide to use a spreadsheet tool that changes how cells appear when they contain the word yes. which tool do you use? 1 point conditional formatting data validation concatenate filtering 5. question 5

Respuesta :

Conditional formatting is the tool to change how cells appear when they meet a certain value.

Conditional formatting

It is simple to highlight specific values or make specific cells obvious using conditional formatting. This modifies a cell range's look according to a criterion (or criteria). To highlight cells that contain values that meet a specific requirement, use conditional formatting.

Utilize conditional formatting according to the text in a cell

  1. Choose the cells to which conditional formatting should be applied. Drag from the first cell of the range to the last cell.
  2. Select Text that Contains by selecting HOME > Conditional Formatting > Highlight Cells Rules. Enter the text you want highlighted in the Text that Contains box on the left.
  3. Click OK after selecting the text's color format.

To Know more about Conditional Formatting, Check out:

https://brainly.com/question/16014701

#SPJ4