Copy and paste problem in Excel

Microsoft Excel for mac 2011 - macintosh
January 31, 2011 at 13:36:54
Specs: Macintosh
I am trying to make a simple calender like spread sheet of the days/hours that my wife and I work each week. If my wife and are not working during the same date/hour, I have the corresponding cell show blue, if either one of us is working the cell shows red.

If she works from say 6am to 8am on monday she puts a "1" in the corresponding box. If I work 10-11am on monday I do the same in my area. Then the third weekly calender shows blue in any time block we both are not working. As seen here ---->http://i826.photobucket.com/albums/zz188/ttimblin/excel1.jpg

I used a conditional "Formula is" format for cells J3:J22. Seen here for cell J3 ----->http://i826.photobucket.com/albums/zz188/ttimblin/excel2.jpg

How do I get the formula to be copied over to the rest of the calender??!?!? Every time I highlight and drag the + cursor over the rest of the cells it does not change the column assignment. Eg. from "=$B$3+$B$27=0" to "=$C$3+$C$27=0" for Tuesday, and "=$D$3+$D$27=0" for Wednesday and so on.

It will take me forever to format each cell individually.

Please save me! Thanks!


See More: Copy and paste problem in Excel

Report •


#1
January 31, 2011 at 17:11:47
=$B$3+$B$27=0

Using the Dollar Sign Anchors that column or row.

If you want the column to change but not the row, when you drag try:

=B$3+B$27=0

If you want the row to change but not the column, when you drag try:

=$B3+$B27=0

MIKE

http://www.skeptic.com/


Report •

#2
February 2, 2011 at 01:07:43
Sweeeet!

I showed my fun project to my friends and they think I'm a dork. Thanks!


Report •

#3
February 2, 2011 at 07:11:08
and they think I'm a dork

Let loose the inner nerd. :-)
.

Glad you got it working.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question