protect & ifstatement 4

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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
Hi Frank,

Check attached...
Frank_S_Cond_Form.xlsx
RaminTechnical Advisor

Commented:
Frank .SBuilding Estimator

Author

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.
Ensure you’re charging the right price for your IT

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

Frank .SBuilding Estimator

Author

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 Estimator

Author

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.
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Frank,

Check attached...
Frank_S_Cond_Form_v2.xlsx
RaminTechnical Advisor

Commented:
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 Estimator

Author

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.
Technical Advisor
Commented:
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
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
No Comments added further.

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