Thread: Excel Question
View Single Post
Old 20-04-2019, 16:49   #1
Mike
cf.mega poster
 
Join Date: Jan 2004
Age: 61
Posts: 2,242
Mike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful oneMike is the helpful one
Excel Question
Hi there.

Hope someone could please help on this....

It's an excel question about copying and pasting formulas..

Thought I would attached a spreadsheet which has my problem !

On tab1 I have 100 months of a data % going 'across' the page with a conditional format giving me a green amber red traffic light under each month.

I need to complete sheet 2 and I am trying to copy the formula and then paste it but in this cases going 'down' the page.

Having real problems simply copying the green amber or red onto tab 2 column c and then copying it down 100 lines.

Maybe I am doing something stupid but would appreciate any ideas on the best way of doing this.

Really appreciate any help and thanks for your time

Regards

Mike
Attached Files
File Type: doc Excel Question.doc (57.0 KB, 12 views)
Last edited by Mike; 20-04-2019 at 16:57.
Mike is offline   Reply With Quote