In Part One of this blog posting, we’ve already looked at using Conditional Formatting to identify duplicates (and unique values).

In the second scenario, I’m going to look at where we have a list of rooms/dates/times and we want to see if there are any clashes – so I’m going to use concatenation (not as daring as it sounds ๐Ÿ™‚ with conditional formatting to identify clashing appointments.

View the video below


Here is the file for you to practise on. Also note that in this sheet one column has been set up with a dropdown list which I show you how to create here.ย 

As always, comments and feedback welcome.