Or something similar? I will have 3 sheets total. The first sheet will have the field numbers and the gallons per minute. I want to put the circles (center pivot) in to groups. The groups will have different colors and fill a cell when selected. I have that part working with conditional formatting. In column C I would like to have something to check or click, mark? When it is marked add it to sheet 2, or if it is unmarked delete it from sheet 2. Plus add the filled color across the sheet. Sheet 2 is our weekly water schedule. I have it up and running fine but want to do more with it, like the stuff I have all ready mentioned. It is black and white and has colored check marks and x's. Sheet 3 I want for a daily schedule that shows the water changes for that day. If a circle is on Monday and Tuesday off Wednesday I would like it to show that field came on Monday show nothing for Tuesday and show off for Wednesday. One more thing to add to it the diffrents in the total gallons for that day from the day before. (I think I can figure that part out) But the rest is over my head. I will try to upload what I have.
Thanks Reddog