Hi everyone,
I have set up a VBA and from that I get Names in cells A and in b1, b2 etc I have the up to date number which is refreshed every 2 minutes numbers and saved into the next available cells (c1, d1 etc). Eventually there will be 20 - 30 players so data will be quite hard to read.
I have managed to set up conditional formatting so that if cells c1 to h1 are equal to b1 the colour is orange, if less then blue and greater than is green.
At present I can only do it so that it is always linked to b1, but if you see the attachment I am wanting it so each cell is conditional formatted against the previous cell ie c1 is linked to b1, d1 to c1 etc. I can do this but only by setting each conditional format manually, so when I do have 20 players and inormation going up to cells BB it will be too much to carry out manually. is there a way to set something up so this can be set up automatically?
Sorry I find this hard to explain but hopefully the attachment will help.
Thanks in advance
Julie
Bookmarks