• Status: Solved
  • Priority: Low
  • Security: Public
  • Views: 42
  • Last Modified:

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.

conditional formatting 2.1
0
Frank .S
Asked:
Frank .S
1 Solution
 
Frank .SBuilding EstimatorAuthor 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
0
 
Ryan ChongCommented:
i got replied you in your another question. see if that works for you?
0
 
RaminTechnical AdvisorCommented:
Try attached file,
Test.xlsx
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
Answer deleted as Ramin posted the same answer. :)
1
 
RaminTechnical AdvisorCommented:
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.
0
 
RaminTechnical AdvisorCommented:
Thanks,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now