Dependent conditional formatting in excel 2013

[pradeepswalse]

Hi,

I need help regarding dependent conditional formatting in excel 2013. I tried lot as per knowledge but not successful.
Sample Excel file is attached.

Example given below :
Case 1 : If user selected 'ALLOW 1 or ALLOW 2 or ALLOW 3 or ALLOW 4' from dropdown of column C (Select) then user is not allowed to enter value in respective cells of Column E (Col 2) and Column F (Col 3). These cells should change cell fill color to red and Column D (Col 1) color to green.

Case 2 : If user selected 'REJECT 1 or REJECT 2 or REJECT 3 or REJECT 4' from dropdown of column C (Select) then user is not allowed to enter value in respective cells of Column D (Col 1) and Column F (Col 3). These cells should change cell fill color to red and Column E (Col 2) color to green.


Case 3 : If user selected 'TEST 1 or TEST 2 or TEST 3 or TEST 4' from dropdown of column C (Select) then user is not allowed to enter value in respective cells of Column D (Col 1) and Column E (Col 2). These cells should change cell fill color to red and Column F (Col 3) color to green.

Drop down list is created on 'Sheet 2'
If someone needs more details or query then you can email me on [email protected]

Admin, You can move this query in correct thread if posted by me in wrong thread.


Regards,

Pradeep S. Walse

[6StringJazzer]

I have done the first one for you as a model, attached. You should be able to do the rest based on that.

You need two rules for each case--one rule for the green column, one rule for the red columns.

The formula for both rules is

=LEFT($C5,5)="ALLOW"

You will apply this to one column to set it green, and to the other two to set them red.