Fill Color based on multiple conditon

Hi Friends, Appreciate your support in advance.

A sample worksheet is attached, in which if column C&D=0 then column B containing "CHERRY" of the same row must be filled with Green color, and if all columns B containing "CHERRY" are filled with Green color, then column A containing "PAUL" must be filled with Green color.

VBA or Conditional formatting anyone will do.

Thanks
Elvis.

first of all get rid of your merged cells, they can play havoc with the case you are trying to solve.
click on one of the merged cells and see what cell reference you choose.
as your illustration has a varying number of rows associated with the merged cell(name) imagine keeping track of this in an application involving hundreds of rows.

Thanks Torachan. I am working in Oil & Gas, here in Column A we have System and Column B Sub-system. System have one or more Sub-sytem which have some tasks which are mentioned in column C, D and goes on. If all the tasks for Sub-system gets completed then the System (Merged Cells) which also gets completed. My manager will ask if any Sub-system or System gets completed, at that time I need to check one by one which will be time consuming. So I asked for some help here.
If merge cells give problems then please guide me with some other methods for the above situtation.

Thanks,
Elvis.

In column 'A' get rid of the merged cells and put the persons name into each cell then the association along the row is complete.
before proceeding any further why is 'apple' & 'banana' coloured green ??? - does not appear to follow your description.

Rule for A1:

=AND($A1<>"",SUMPRODUCT(($A$1:$A$9=$A1)*($C$1:$D$9=1))=0)

Applies to: =$A$1:$B$9

Rule for B1:

=AND($A1<>"",COUNTIF($C1:$D1,1)=0)

Applies to: =$B$1:$B$9

To be clear: my CF formulae do NOT give an error. They do exactly what you asked for based on your original sample file.

My CF formulae just need tweaking to fit the new data layout. You have made NO ATTEMPT to tweak them. Please do so now and attach the file if you cannot make it work.

So you aren't even going to show me WHAT you tried? I'd like to see a bit more effort from you, otherwise you won't learn anything from this.

Have a look at the attached.

Is this what you want?

=AND($C6<>"",SUMPRODUCT(($C$6:$C$108=$C6)*($H$6:$H$108=0)*($N$6:$N$108=0))=COUNTIF($C$6:$C$108,$C6))

No reply ...

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

No worries. Please mark as solved.