|re: "I wish to expand the formula in column F to fill cells Green for meeting compliance and Red for non compliance."|
You can't change a cell color via a formula in a cell. The only place you can use a formula (or "Rule") to change a cell color is via Conditional Formatting
re: "Conditional formatting has not worked as the figures in column C vary "
That's the whole idea behind Conditional Formatting. As cell values "vary" the conditions are met or not met (TRUE or FALSE) and the either the formatting is applied or it isn't.
You gave us a formula, but you didn't tell us what is in Columns C, D or E, so it's kind of hard for us to tell you what to do with Column F.
What is the relationship between the values in Column C and F and how do they determine whether an organisation is in compliance or not?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.