Miguelluis
New Member
- Joined
- Jan 29, 2013
- Messages
- 45
Hi,
I've got a sheet with data as follows
<tbody>
</tbody>
I wanted to concatenate only if the cells or font is formatted with the colour red and list the items in separate lines, like below:
<tbody>
</tbody>
Assuming that the above correspond to the cells that were highlighted.
Is there a way of doing this?
Thanks
Miguel
I've got a sheet with data as follows
Client | Name 1 | Name 2 | Name 3 |
1234 | Passport | DL | Utility |
456 | Passport | DL | Utility |
778 | Passport | DL | Utility |
<tbody>
</tbody>
I wanted to concatenate only if the cells or font is formatted with the colour red and list the items in separate lines, like below:
1234 | -Passport -DL -Utility |
456 | -Passport |
778 | -DL -Utility |
<tbody>
</tbody>
Assuming that the above correspond to the cells that were highlighted.
Is there a way of doing this?
Thanks
Miguel