protect & ifstatement 4

hi experts, i would like to make a modification to the attached workbook.
The criteria are listed under the data in the worksheet of the attached workbook.
protect---ifstatement-4.xlsx
Frank .SBuilding EstimatorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ShumsExcel & VBA ExpertCommented:
Hi Frank,

Check attached...
Frank_S_Cond_Form.xlsx
RaminTechnical AdvisorCommented:
Frank .SBuilding EstimatorAuthor Commented:
hi shums, it appears you have deleted the previous conditional formats in the worksheet which still needs to remain, the criteria on my attached worksheet were additional requirements, none of the previous requirements should have been deleted or modified.
Get Blueprints for Increased Customer Retention

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

Frank .SBuilding EstimatorAuthor Commented:
hi ramin, if you see the following screenshot you will see that;
- e3 should not be red, but have no formatting
- also part of the criteria for column 'h' are columns 'g'

screenshot 4.1
Frank .SBuilding EstimatorAuthor Commented:
- also part of the criteria for column 'h' are columns e & g as per criteria listed below the data in the worksheet

therefore in row 3 for example, the cells that should have a green background are; a:c, e, g, h, because h3 = "checked".
If h3 = "to check" then the only change would be that the same cells would have a red background instead of green.
ShumsExcel & VBA ExpertCommented:
Frank,

Check attached...
Frank_S_Cond_Form_v2.xlsx
RaminTechnical AdvisorCommented:
If you don't want to apply yellow rule to column E  anymore then just select E3:E7
Check Attached:
protect---ifstatements_5--2-.xlsx
Frank .SBuilding EstimatorAuthor Commented:
hi ramin, the worksheet now works and is all dependant upon column 'h', but the original criteria on column 'e' no longer works?
the criteria for this question was in addition to the previous question not to replace.
i still need if column 'e' >= 'f1' should show in red, if less than 'f1'-1 to show in yellow, and if doesnt meet any of this criteria to show no formatting.
RaminTechnical AdvisorCommented:
therefore in row 3 for example, the cells that should have a green background are; a:c, E, g, h, because h3 = "checked".
If h3 = "to check" then the only change would be that the same cells would have a red background instead of green.



Please answer this question.

If "H3"  is "checked"  and E3 is equal to  f1-1 then E3 must be Green or yellow ?

and do you want "E" column to be independent from "H" value and only be depend on "D1" ?

Please check attached file.
protect---ifstatements_6.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ShumsExcel & VBA ExpertCommented:
No Comments added further.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.