..but with a twitch:
I have 50 names in colon A with 50 values in colon B, all in MAIN sheet, that I get by referencing to appropriate colon in one of 50 other sheets that are refreshed via "get external data from web" option.
Where my problem lies is in bonus sheet i made, in which i want to preserve those values on daily basis. so, for day 12 i have separate colon in which i manually paste values from main sheet, for day 13 also, and so on.
I WANT to, well, sort of, conditionally format every colon (apart from first) with a set of rules like:
IF day 13 cell is by 4 to 6 larger than appropriate one in colon 12, COLOR IT RED
IF day 14 cell is by 6 to 10 larger than appropriate one in colon 13, COLOR IT GREEN
IF day 15 cell is by 10 to 25 larger than appropriate one in colon 14, COLOR IT YELLOW
i have a really large table there, so i want to automate it as much as possible.
P.S. It has been a long time since i asked a question here, but i remember this forum as a great and helpfulll comunity, so please, i need help fast, i'm stuck in a infinite loop.
Bookmarks