Please help!
All cells in my spreadsheet are bold. Through conditional formatting, I have removed the bold font from certain cells. Now I would like to keep the results of the conditional formatting while removing the conditional format. This is so any changes made to cells will not become bold again upon modifications. I ultimately would like to copy and paste the values and formats without the conditional format logic in effect any more.
Process is as follows:
1. File received, all cells bold.
2. For all cells containing "<" symbol, remove the bold font.
=SEARCH("<",A1) font style:Regular
3. Remove the "<" symbol, do not have the conditional format change the number bold.
Data in the process to look like this:
1.
<.005
.004
2.
<.005
.004
3.
.005
.004
Every time I take the < symbol, the conditional format makes the cell bold.
All cells in my spreadsheet are bold. Through conditional formatting, I have removed the bold font from certain cells. Now I would like to keep the results of the conditional formatting while removing the conditional format. This is so any changes made to cells will not become bold again upon modifications. I ultimately would like to copy and paste the values and formats without the conditional format logic in effect any more.
Process is as follows:
1. File received, all cells bold.
2. For all cells containing "<" symbol, remove the bold font.
=SEARCH("<",A1) font style:Regular
3. Remove the "<" symbol, do not have the conditional format change the number bold.
Data in the process to look like this:
1.
<.005
.004
2.
<.005
.004
3.
.005
.004
Every time I take the < symbol, the conditional format makes the cell bold.
