Question

Which of the following feature lets you highlight positive values with green background colour and negative values with red quickly? *
Conditional Formatting
Sorting
Custom filtering
Cell formatting​

Answer 1

Answer:

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.