Spreadsheet: 297653d1392498554-copy-cells-with-conditional-formatting-excel-2007-problem
Sheet: DOR1

Recruit |  |  | Daily Performance |  |  |  |  | Officer Responding to Training
FTO | TESTING |  | Daily Average |  |  |  |  | Remedial Training Necessary |  |  |  |  | YES
Date | 11/20/2013 |  | Recruit Initial |  |  | MS |  | Counseled on Deficiencies |  |  |  |  | No
Shift | Graves |  | FTO Initial |  |  | MD |  |  |  |  |  |  | NRT |  |  | I need to copy cells A32:N41 which contain conditional formatting.
N/O | NRT | 1 | 2 | 3 | 4 | 5 | 6 | 7
0 | 15 |  |  | APPEARANCE |  |  |  |  |  |  |  |  |  |  |  | I need to make about 40 copies.  When I do this the conditional formatting
 |  |  |  | General [NAME] |  |  |  | 7 |  |  |  |  |  |  |  | stays attached to the original cells.  The formatting is based off
 |  |  |  | Activity |  |  |  |  |  |  |  |  |  |  |  | of the data in cells E33:E39 and J33:[NAME]
 |  |  |  | Self Initiated Activity
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If the number falls between 1 and 3 the cells will turn red between 4 and 7 the cells will turn green
PERFORMANCE
Radio Communication |  |  |  |  |  |  | Criminal Code / City Ordinances |  |  |  |  |  |  |  |  | If the [NAME] is NRT it will turn black and N/O turns white
Orientation  / Response Time to Call |  |  |  |  |  |  | Department Policy / Procedures
Motor Vehicle Operation |  |  |  |  |  |  | Criminal Procedures |  |  |  |  |  |  |  |  | Then in cells [NAME]:N39 if any of the cells E33:E39 and J33:[NAME] equal NRT,1,2,or 3 the cells will turn yellow
Field Performance Tactical Procedures / Control of Conflict |  |  |  |  |  |  | Traffic Enforcement / Accident Investigations
Field Performance Normal and Stress Conditions |  |  |  |  |  |  | Written Communications |  |  |  |  |  |  |  |  | Then in cells [NAME]:N39 if any of the cells E33:E39 and J33:[NAME] equal NRT,1,2,or 3 the cells will turn yellow
Officer Safety |  |  |  |  |  |  | Mobile Computer |  |  |  |  |  |  |  |  | formatting does not come across attached to the new cells. So if I was to copy all of the information to
Problem Solving / Decision making / [NAME] |  |  |  |  |  |  | Interpersonal Relationships |  |  |  |  |  |  |  |  | cells A42:N51 the conditional formatting for cells K45:N49 will only change to yellow when cells [NAME]:J39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and J33:[NAME] meet the requirements
Least Acceptable Performance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | And the check boxes also do not come across.
 |  |  |  |  |  |  |  |  |  | Graves
Most Acceptable Performance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need to copy this at least 40 times and I was looking for a short cut so I do not need to add the
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | conditional formatting to each cell.
Additional Comments |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I am using [NAME] 2007 and Windows 8
Recruit  Comments
1 - Case #: |  |  |  |  | Type of Call: |  |  |  |  | Was Call Dispatched of Self Initiated
Radio Communication |  |  |  | 5 | Criminal Code / City Ordinance |  |  |  | 4 | Dispatch Call
Orientation / Response time to calls |  |  |  | 4 | Department Policy / Procedures |  |  |  | N/O | Self Initiated Activity
Motor Vehicle Operation |  |  |  | N/O | Criminal Procedures |  |  |  | 6 | How Were NRT's and 1-3 Remediated
Field Performance Tactical Procedures / Conflict Control |  |  |  | 6 | Traffic Enforcement / Accident Investigations |  |  |  | N/O | Field Perform |  | Written Test
Field Performance Normal and Stress Conditions |  |  |  | 4 | Written Communication |  |  |  | 4 | Role Play |  | Verbal Test
Officer Safety |  |  |  | 6 | Mobile Computer |  |  |  | 5 | Certification |  | Other
Problem Solving / Decision Making / Common Sense |  |  |  | 7 | Interpersonal Relationships |  |  |  | NRT | EXPLAIN IN COMMENTS
 |  |  |  |  |  |  |  |  |  | True