Forum Discussion
setting icon set limits using formulae?
Hi there
I want to set up a status report to update each quarter and want to use condition formatting to show how on trackthe organisation is depending on where we are in the year. What i want to b...
Hi Clare,
Without concrete sample hard to say. As variant and very approximate -
let say you calculate <% achieved> and <time zone> for which it is calculated (.25 for Q1; 0.5 for Q2; 0.75 for Q3 and 1 for Q4). When <annual approximation> = <% achieved>/<time zone>.
After that you create three rules in conditional formatting (one for each color) using a formula, e.g. for red
=<annual approximation> <= 0.25
select format and apply to cell(s) to highlight.
Something like this.