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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

ShumsDistinguished Expert - 2017Commented:
Hi Frank,

Check attached...
Frank_S_Cond_Form.xlsx
1
RaminTechnical AdvisorCommented:
1
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.
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
0
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.
0
ShumsDistinguished Expert - 2017Commented:
Frank,

Check attached...
Frank_S_Cond_Form_v2.xlsx
1
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
0
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.
0
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
0

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
ShumsDistinguished Expert - 2017Commented:
No Comments added further.
0
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.