Hi all,
I have some data in a KPI sheet where I would like to setup conditional formatting to dedide if the cell should turn GREEN (0-5% deviation compared to base), YELLOW (5-10% deviation compared to base), RED (above 10% deviation compared to base).
Example:
My budget for the department is 100. If the actual end up on either 102, 107 or above 110 I would like the conditional formatting to show respectively GREEN, YELLOW and RED for the respective cells.
I don't really know how to setup the formula. I have attached a spreadsheet with an example to make it easier for people to understand my challenge.
Regards,
Klaus
Bookmarks