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

I used a conditional "Formula is" format for cells J3:J22. Seen here for cell J3 ----->

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 •

January 31, 2011 at 17:11:47

Using the Dollar Sign Anchors that column or row.

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


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



Report •

February 2, 2011 at 01:07:43

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

Report •

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

Let loose the inner nerd. :-)

Glad you got it working.


Report •

Related Solutions

Ask Question