Frank .S
asked on
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.
i got replied you in your another question. see if that works for you?
Try attached file,
Test.xlsx
Test.xlsx
Answer deleted as Ramin posted the same answer. :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks,
ASKER
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