mjg060468
02-04-2010, 03:39 AM
Hi have attached excel spreadsheet.
I have got 99% of it done. But I have one issue.
The purpose of the spreadsheet is to track performance over certian criteria. If the figures entered are below 90% of the target the box goes red and generates an action plan in the boxes below. If they are between 90% 99.9% the box is orange. If 100% or more box goes green.
This all works, issue I have is one of the targets is sometimes a minus figure. This seems to throw all the formulas out. Could someone have a look for me and let me know how the formula needs to look in the conditional formatting.
Thank you
I have got 99% of it done. But I have one issue.
The purpose of the spreadsheet is to track performance over certian criteria. If the figures entered are below 90% of the target the box goes red and generates an action plan in the boxes below. If they are between 90% 99.9% the box is orange. If 100% or more box goes green.
This all works, issue I have is one of the targets is sometimes a minus figure. This seems to throw all the formulas out. Could someone have a look for me and let me know how the formula needs to look in the conditional formatting.
Thank you