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