Use the following formula for Conditional FormatA1="Registered" or A1="Advertised"
=OR(A1="Registered",A1="Advertised")
Check this and revert - to turn redA1<>"Registered" or A1<>"Advertised"
=OR(A1<>"Registered",A1<>"Advertised")
It doesn't work. kind of syntex errorHow aboutExcel Formula:=and(A1<>{"Registered","Advertised"})