conditional format 2.1

Frank .S
Frank .S used Ask the Experts™
on
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.

conditional formatting 2.1
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Frank .SBuilding Estimator

Author

Commented:
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 ChongSoftware Team Lead

Commented:
i got replied you in your another question. see if that works for you?
RaminTechnical Advisor

Commented:
Try attached file,
Test.xlsx
Subodh Tiwari (Neeraj)Excel & VBA Expert
Most Valuable Expert 2018
Awarded 2015

Commented:
Answer deleted as Ramin posted the same answer. :)
Technical Advisor
Commented:
Answer deleted as Ramin posted the same answer. :)
Thanks,  I know you are excellent in Excel and please accept my apologies to enter into your territory.


@Frank

Select all the cells that you want to apply conditional formatting.
from Home tab select conditional formatting.
Manage rules ...
New rule ...
Format only cells that contain
change "between" to "equal to".
Type: To Check
click on format
Fill
pick a red color
OK.
OK.
New rule ...
Format only cells that contain
change "between" to "equal to".
Type: Checked
click on format
Fill
pick a green color
OK.
OK.
OK.
RaminTechnical Advisor

Commented:
Thanks,

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial