I have a report that exports from a system in the following format:
<tbody>
</tbody>
How can I apply conditional formatting to have the output show like this:
<tbody>
</tbody>
Project | Project Name | Deadline | Person Assigned | Person Role |
0045 | Red Project | 1/1/2015 | Jane Doe | Manager |
Pat Rogers | Approvals | |||
0092 | Project Blue | 1/15/2015 | Jane Doe | Manager |
Sue Green | Coordinator | |||
Chuck Smith | Coordinator | |||
Pat Rogers | Approvals | |||
0055 | Purple Account | 2/1/2015 | Jane Doe | Manager |
Chuck Smith | Coordinator | |||
Pat Rogers | Approvals |
<tbody>
</tbody>
How can I apply conditional formatting to have the output show like this:
Project | Project Name | Deadline | Person Assigned | Person Role |
0045 | Yellow Project | 1/1/2015 | Jane Doe | Manager |
Pat Rogers | Approvals | |||
0092 | Project Blue | 1/15/2015 | Jane Doe | Manager |
Sue Green | Coordinator | |||
Chuck Smith | Coordinator | |||
Pat Rogers | Approvals | |||
0055 | Purple Account | 2/1/2015 | Jane Doe | Manager |
Chuck Smith | Coordinator | |||
Pat Rogers | Approvals |
<tbody>
</tbody>
Last edited: