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

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