How To... Use Basic Conditional Formatting with an IF Statement in Excel 2010
Here's a handy tip to combine an IF statement with conditional formatting. You can now have a basic visual representation of your data. This example uses pass/fail rates to illustarate how this works.