Hi Guys and Gals,
Looking for some help in setting up a document for work. I have currently made the SS sum "/" count cells to stop the display from simplifying the fraction, because it needs to be a direct count not a percentage/simplified fraction for work reason. This unfortunately throws up a new issue when i link this information to another page for easy reading of different members of the team. What i would really like to do is somehow format these linked cells to look for:
If x < y in x / y, then go red, if x = y in x / y, then go green.
Any ideas on how i get excel to do this when the cell is formatted in the other sheet to stay as text not a fraction?
Thanks for you help.
Bookmarks