Question

Which of the following ways can you apply conditional formatting to a cell?

A) By date
B) By text contained in the cell
C) By a number in the cell
D) By an image in the cell

Answer 1

You can apply conditional formatting to a cell by date, by text contained in the cell, or by a number in the cell.

Step-by-step explanation:

The correct ways to apply conditional formatting to a cell are:

1. By date: You can set up rules based on specific dates or date ranges to format cells accordingly. For example, you can highlight cells that are due within a week.
2. By text contained in the cell: You can format cells based on the content of the text. For instance, you can highlight cells that contain certain words or phrases.
3. By a number in the cell: You can apply formatting based on the numerical values in the cells. For instance, you can set rules to highlight cells that are above or below a certain threshold.