Google Sheets Countif function does not highlight the whole row-CodePudding

Home > Net > Google Sheets Countif function does not highlight the whole row

Google Sheets Countif function does not highlight the whole row

Time：08-26

The Condition formatting 'Countif' did not highlight the whole row even adding $.

=Countif($H$3:$H$9,H3)>1

Did I miss something?

Thanks.

CodePudding user response：

Apply to range: H3:I10

Formula: =Countif($H$3:$H$10,$H3)>1