measuring against the baseline

I am trying to get a formula that acts as a "early warning" spot light in the number field against the finish variance e.g. if my base line finish is 40 days. What I want help with is the IF formula

  • if the finish is 40 days away or greater then the symbol is green
  • if the finish is between 11- 20 days away othen the symbol is amber
  • if the finish is 0-10 days away then the symbol is red
  •  

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts