I have 4 columns - column C has the organisation compliance figure to be met by departments for certain training and column F has the formula to calculate from columns D and E where a department within the organisation are currently at e.g. =SUM(100-E3/D3*100). I wish to expand the formula in column F to fill cells Green for meeting compliance and Red for non compliance. What formula could achieve this? Conditional formatting has not worked as the figures in column C vary - is there a formula to determine what cells to format? Assistance appreciated MM

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

conditionsare 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.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History