Quote:
Originally Posted by Mike
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
|
Have you tried the text to columns under the data option