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
The criteria are listed under the data in the worksheet of the attached workbook.
protect---ifstatement-4.xlsx
Try This:
protect---ifstatements_4.xlsx
protect---ifstatements_4.xlsx
ASKER
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.
ASKER
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'
- e3 should not be red, but have no formatting
- also part of the criteria for column 'h' are columns 'g'
ASKER
- 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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
Check Attached:
protect---ifstatements_5--2-.xlsx
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No Comments added further.
Check attached...
Frank_S_Cond_Form.xlsx