Minute 08:00 — 09:00

any other conditional formatting rule is this duplicate values so i’ll start with that really quick and i’ll kind of show you a few of these other ones but this duplicate values to me is one of the most useful ones and so let’s kind of show you how that works if you go to the start date you can see that we have a duplicate value right here and if we go over here to conditional formatting highlight cells rules and duplicate values it is going to highlight

the duplicate and that says duplicate right here now we can go through here and click on unique and then it would highlight all the ones that are not duplicates so you can use it you know kind of in a similar inverse way it’s just different different but i use the duplicate almost always another thing that you can do is go over here and you can change the color or you can even do a custom which i never do that’s not something i spend a lot of time doing i