change cell colour when other cell(s) are green

[Gerald Baalhuis]

Hi you all,

Is it possible to use conditional formatting where the colour of a cell is set by the clour of a group of other cells?
I have a worksheet with 400+ companynames, all of which have one or more (up to 12) departments. I already found some VBA code to show the dept. s when a checkbox (which is next to the company name) is selected, but I would like to color the cell with the company name in it green as soon as all cell containing the dept. of that company are green.
Can that be done by cond. format.? Or VBA perhaps?

Thanks in advance,

Gerald

 

[Juan Pablo González]

What's the condition for a dept. to be green? I would use those instead in the conditional format of the company instead of going with VBA.

 

[Gerald Baalhuis]

Hi Juan,

The condition of the dept. cell to turn green is wether that dept.'s order is completed.
A worker doubleclicks the cell which contains the dept. name thus colouring it green with some VBA code.
I would like the cell with the company name green as soon as all dept. cells are green.
But as the numbers of dept. differs for each company, I think it's a tricky (if not impossible) thing to do with cond. form.


Gerald
(the Netherlands)

 

[Juan Pablo González]

I see,

Then use the same doubleclick code to check if all the departments have been colored green. That way, as soon as the user double clicks on the last department, the company also turns green.