Excel: Conditional format based on percentage of a value

My spreadsheet has two financial columns. Column A has a financial target in £'s, column B has the amount in £'s that was actually brought into the business. I want to conditionally format column B to show the colour red if less than 80% of the target value is achieved, amber if 80-99% is achieved and green if 100% or more is achieved. I know that this can be done with a formula based conditional format with three rules, however the formulas that I have tried have all resulted in the entire column being highlighted in just one colour. The spreadsheet is an excel 2010 spreadsheet. Thank you for your help.

This question generated 13 answers. To proceed to the answers, click here.

This thread is current as of August 20, 2014.

For more resources for Microsoft Excel