Question

Which of the following features lets you highlight positive values with green
background colour and negative values with red quickly?
(1) Sorting
(ii) Conditional Formatting
(iii) Custom Filtering
(iv) Cell Formatting
in Excel?.​

Answer 1

Answer:

Highlight Negative Numbers in Red – Using Conditional Formatting

   Go to Home → Conditional Formatting → Highlight Cell Rules → Less Than.

   Select the cells in which you want to highlight the negative numbers in red.

   In the Less Than dialog box, specify the value below which the formatting should be applied. ...

   Click OK.

Explanation:

Answer 2

Answer:

Conditional Formatting

Explanation:

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 satisfy a specific requirement, utilize conditional formatting.

Click the arrow next to Conditional Formatting in the Style group on the Home tab, and then select Highlight Cells Rules.

The command you desire, such as Between, Equal To Text that Contains, or A Date Occurring, should be selected.After entering the desired values, choose a format.

There are different categories of conditional formatting visualizations:

• Shading of background colors (of cells)

• Primary Color Shading (of fonts)

• Number Bars

#SPJ2