conditional formatting

[ysherriff]

Can someone please check the file to see why my conditional formatting is not working. The tab in question is "Bishop,Jennifer Roach"

I am trying to underline referral source that are unique.

I know it is something simple but I tried almost everything and having a rough time at it.

Here is the link:

https://www.dropbox.com/s/1uk0gaqot7mrrtl/Market Hospital Alignment Template v1.7.xls


Thanks for your help

 

[Somendra Misra]

Hi,

Try changing the formula of CF to =COUNTIF($D7:$D105,$D7)=1

Regards,

 

[ysherriff]

did not work Misra

 

[bhasoriya]

Hello Ysherriff,

Have tried here as my knowledge. Hoping that it can help you.

Thanks.

 

[Somendra Misra]

@ysherriff

Try =COUNTIF($D$7:$D$105,$D7)=1

Regards,

 

[ysherriff]

i tried the countif and it still not working. i don't know what could possibly be wrong.

 

[Somendra Misra]

In your sample file, there is no no Unique data.

Regards,