We help IT Professionals succeed at work.

protect & ifstatement 4

158 Views
Last Modified: 2017-11-30
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

ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
Hi Frank,

Check attached...
Frank_S_Cond_Form.xlsx
RaminTechnical Advisor
CERTIFIED EXPERT

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.
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
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
RaminTechnical Advisor
CERTIFIED EXPERT

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
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
ShumsManaging Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018

Commented:
No Comments added further.