Hi all,

Apologies if this question has already been asked, but I've searched high and low and can't find an answer (perhaps I've been using the incorrect terms, I'm not sure).

I have dependant dropdown lists in 4 cells in 4 columns, F13 G13 H13 I13

I want to be able to change those cells' colours to green when the user chooses a value for the final cell (I13).

My knowledge of conditional formatting is pretty terrible; I've played around with a few bits and pieces but to no avail.

Can anyone help me?