I'm struggling with this one.
I have a spreadsheet which has two columns (M & N) which illustrate the Annual Target Total vs. The Actual Total.
I would like to be able to show a traffic light in column N which identifies whether the actual target was anywhere near the annual target.
E.G. Was N2 equal or larger to M2 - if so, green light.
Was N2 equal or larger to M2-5000 - if so, yellow light.
Was N2 equal or smaller to M2-5000 - if so, red light.
Is this possible?
I've attached the file for information.
Thankyou
Nikki
Bookmarks