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