I have list of employees in one column “A”. And their year ratings or the previous three years in the columns “B, C, and D”. Their new rating for this year will be in the column “E”. I want to do a formula that makes Excel give me if the employee is meeting a giving criteria. i.e. any employee with two rating “S” is meeting the criteria by giving me True or Yes in the column “F”. Or instead make a highlight.

So, is there a way to achieve what I am looking for by Excel?

Yours faithfully,