One-off conditional formatting duplicate exeptions

[chrixpowell]

Hey All!

I'm pretty averagely intermediate with Excel (with help googling things at times haha) however I can't find a solution if one exists for the following..

I'm a wedding videographer and use a spreadsheet to track my bookings/enquiries. I have a simple highlight duplicates conditional format on the 'Event Date' column so that say Customer calls and enquires for a date I already have, once typed, it will highlight and alert me that I'm already booked.

This is very useful however I've started taking on bookings and hiring videographers to attend the events in my place. Therefore occasionally my spreadsheet can and will have two dates that match in the column.

When this happens, I need just these exceptions to NOT trigger the conditional formatting when it happens. Is there a work around for this? i.e., once the data is entered, disable that particular formatting. That said, I would still need it to alert me if further duplicates for that date and all others come up.

Thanks in advance

 

[Artik]

Select the range of data in column C.
Insert conditional formatting with formula (fix formula addressing)

=COUNTIF($C$2:$C$10,$C2)>2

and select colors to warn of more than two duplicate.

Artik