No shit sherlock is used to insult someone who is stating to blatant obvious. similar to "you don'
t say" or "thanks
captain obvious!"
if someone is saying
something obvious instead of saying "no fucking shit" you would add "sherlock" to it just to insult them further.