We show you how to highlight duplicates in Google Sheets using the COUNTIF and ARRAYFORMULA functions under the conditional format rules.

Conditional formatting is one way to help you monitor metrics and Google just introduced it to its popular dashboard.

If you want to show negative numbers in red color in Google Sheets, then you can do this using conditional formatting and custom formatting.