Conditional Format as I paste values

..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.

is it allowed on theese forum to "bump" a topic? i really need an answer on this one.

Can you attach the spreadsheet? I am not able to understand your question clearly.

http://www.excelforum.com/excel-work...-indirect.html

sheet2 in that topic, don't refresh data..

hi Confusus,

Did you get a resolution to your problem?