Hi Pecoflyer,
do you think my formula is wrong? If so have you any suggestions for an alternative formula to the one I have?

I used the FALSE because it's part of the formula that I've used in the conditional data validation (before doing the conditional formatting), if you look at the DV I've done on the actions and status' columns. However that doesnt mean im right, in fact I must be doing something wrong with my conditionl formatting. I'm posting a revised example and any solution appreciated

Thanks