Hi, I am trying to set up a spreadsheet that requires some thought and I'm struggling!
I will have 3 sets of data each with 3 subsets in them. for example A1A2A3, B1B2B3 and C1C2C3. Can the sheet select the highest number from the As,Bs and Cs and give a total? Also can the highest number in the As turn a different colour, same for Bs and Cs??
Any help with this would be greatly appreciated!!
Bookmarks