Conditional Formatting in Excel

September 22, 2011 at 07:55:44
Specs: Windows XP
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


See More: Conditional Formatting in Excel

Report •

#1
September 22, 2011 at 11:12:35
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.


Report •
Related Solutions


Ask Question