Hi there,
I know this is a pretty easy one, but can't get this to work. I have a bunch of data rows and if all the cells are not Bold in a row, then delete the row (just delete within data range, not entire row). Otherwise, if there is a cell in the row that is Bold, then leave row as is.
<tbody>
</tbody>
With above example, I'd only want the Store 3 & Store 7 rows to remain (excluding headers).
Thanks!
James
I know this is a pretty easy one, but can't get this to work. I have a bunch of data rows and if all the cells are not Bold in a row, then delete the row (just delete within data range, not entire row). Otherwise, if there is a cell in the row that is Bold, then leave row as is.
Name | Code |
Store 1 | 500 |
Store 3 | 275 |
Store 7 | 480 |
Store 2 | 450 |
<tbody>
</tbody>
With above example, I'd only want the Store 3 & Store 7 rows to remain (excluding headers).
Thanks!
James