Most valuable professional
  • Hot Topics

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

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel