If you want to use conditional formatting, you'd have to formulate a data-based rule to color cells, not a color-based rule.
An alternative would be a macro that loops through the cells in column B. If you encounter a green cell, loop through the cells below to color duplicates. That would be rather time-consuming, and you'd have to run the macro each time you manually color a cell green.
