I have a table that I have established conditional formatting in rows that
when the rule is met, colours the cell in that row green. I would also like
run some conditional formatting on the columns that says "if the nominated
cells are coloured green, then make the header cell yellow".

I don't know if this can be done but any assistance would be greatly
appreciated.

thanks