Help with countifs formula used in conditional formating

[jojo101]

Have a tabe: Col A has "Dates"; Col B has "Bookings"; Col C has "Tasks"; Cols D:G has Accouning figures. (Attachment)

My first conditional format that I already have in place is that, if there is txt in Col B "bookings", then ALL of those relative dates in Col A are to remain visible(duplicate or not, i must see all bookings dates) See Attachmant "ABD"

The conditional format formula that I'm trying to write is to hide duplicate dates in Col A. When there is txt in Col C, but I want the first of each duplicate date to remain visible, Then Hide the rest of those duplicates.

NOTE: i don;t know if it helps, but if there is txt in Col B, then there is never txt in Col C and Visa vera,(txt is in either B or C, not both)

I have tried to use =AND(B2="",COUNTIF(A$2:A2,A2)>1,COUNTIFS(A$2:A2,A2,C$2:C2,"<>")>1) but as you can see from attachment "ABM" it has not worked, i don't konw why. For the purpose of this example I have changed the fomat color from white txt to color to make it eady to see what's happening. any help Plese.

[DBY]

Hello
Not sure if I've understood you correctly but Try CF formula:

Please Login or Register  to view this content.

Applied to A3:A70

Hope this helps.
DBY

[jojo101]

Thank You Very Much, Your a gem, this worked perfectly!