conditional format 2.1

hi experts, i have applied conditional formatting to my worksheet as per my screenshot below, but the problem i have is that there is an error. i only wanted there to be 2 conditions which if they = a word it is displayed with either a green background or red background, if the cell does not = either word "a" or "b" then i dont want anything to be applied to the cell, it is to remain as is, please assist.

Microsoft ExcelMicrosoft Office

Last Comment

Ramin

8/22/2022 - Mon

Frank .S

11/5/2017

ASKER

condition 1. if cell = to check then show background in red fill
condition 2. if cell = checked then show background in green fill
condition 3. if cell does not = either condition 1 or 2 then dont apply any formatting, cell to remain as is

Ryan Chong

11/5/2017

i got replied you in your another question. see if that works for you?

Ramin

11/5/2017

Try attached file,
Test.xlsx

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!

James Murphy

Subodh Tiwari (Neeraj)

11/5/2017

Answer deleted as Ramin posted the same answer. :)

ASKER CERTIFIED SOLUTION