I see where I was going wrong now Maud, I typed my formula as =$C$11="Röd dag" instead of =$C11.......
Many thanks for your help with this Maud.