easy5 pts · first answer countsexcelconditional-formatting

Highlighting overdue amounts

You want amounts above ₹1,00,000 in column D to turn red automatically. Which feature should you use?

A.Data Validation > Decimal, greater than 100000B.Format Cells > Number > CurrencyC.Review > Track Changes for column D onlyD.Conditional Formatting > Highlight Cells Rules

Discussion 0

Join free to post in the discussion.

Highlighting overdue amounts

Discussion 0

Related questions