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

[flowplayer src=’′]


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.