Minute 13:00 — 14:00

can bring all those to the top and so super super useful and another use for it that you may not think of is something like if it’s you know there’s some incorrect data in there this happens often with phone numbers addresses start dates or dates in general date formats where you can go in here and you can say text that contains and if you know you put in a

oops a dash and it has it in there then you know that that is that is wrong now that is really all i wanted to show you in the highlight cells rules

the duplicate values and the text contains are by far the ones i use the most all the other ones i have used

these ones not so much but in these highlight cells rules i use you know these two all the time

sometimes i use this between i don’t really use these other ones as much although i have used them and so if you got nothing else from this video i just wanted you to know that these two are super useful and if you haven’t used