A
aaron
at work i get data from my boss. my job is to set up a speadsheet that
makes it look pretty. I work a lot with "scorecards" where the
backround color would be green red or yellow based up on how the data
looksit used to be that i would use conditional formatting to do this.
but they want to start using "pictures" represent they way data looks.
like stop sign for red or a light buld for yellow you all know th deal
with these stupid things. anyway i set up a macro so i don't have to
keep on copying these stupid picture 250 times on thhe same
spreadsheeet everymonth.. only problem is that t doesn't align well
and i think it has something to do with thw snap to grid feature being
turned off when the spreadsheet is closed there anyway to snap to grid
automaticall when the spreadsheet comes up.. what might be easyier is
to tell it go in the same position when i copy the picture around.
thanks
aaron
makes it look pretty. I work a lot with "scorecards" where the
backround color would be green red or yellow based up on how the data
looksit used to be that i would use conditional formatting to do this.
but they want to start using "pictures" represent they way data looks.
like stop sign for red or a light buld for yellow you all know th deal
with these stupid things. anyway i set up a macro so i don't have to
keep on copying these stupid picture 250 times on thhe same
spreadsheeet everymonth.. only problem is that t doesn't align well
and i think it has something to do with thw snap to grid feature being
turned off when the spreadsheet is closed there anyway to snap to grid
automaticall when the spreadsheet comes up.. what might be easyier is
to tell it go in the same position when i copy the picture around.
thanks
aaron