Avatar of Frank .S
Frank .S
Flag for Australia asked on

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
Microsoft OfficeMicrosoft ExcelMicrosoft ApplicationsSpreadsheets

Avatar of undefined
Last Comment
Shums Faruk

8/22/2022 - Mon
Shums Faruk

Hi Frank,

Check attached...
Frank_S_Cond_Form.xlsx
Ramin

Frank .S

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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Frank .S

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'

screenshot 4.1
Frank .S

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.
SOLUTION
Shums Faruk

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Ramin

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Frank .S

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.
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Shums Faruk

No Comments added further.