Can anyone help with a search and replace of a color font?
I have been given an Excel 2007 sheet with many thousands of entries where color has been used to indicate a particular chemistry (I work for a biotech company). I have the task of converting the color to an unambiguous string representation prior to loading into an alas color-blind relational database. So for example a red G should be 'g', an orange G should be 'Gf', a yellow G should be 'Gm', etc.
<table style="border-collapse: collapse; width: 96pt;" width="128" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" width="64" height="20">input</td> <td style="width: 48pt;" width="64">output</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">GGGGG</td> <td>GGgGfG</td> </tr> </tbody></table>
I've tried setting the formatting in Find and Replace, but I only get 'Excel cannot find a match' even though I'm staring at a red G. Making sure the font name and font size are explicitly set did not help.
Any suggestions?
thanks
I have been given an Excel 2007 sheet with many thousands of entries where color has been used to indicate a particular chemistry (I work for a biotech company). I have the task of converting the color to an unambiguous string representation prior to loading into an alas color-blind relational database. So for example a red G should be 'g', an orange G should be 'Gf', a yellow G should be 'Gm', etc.
<table style="border-collapse: collapse; width: 96pt;" width="128" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" span="2" width="64"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 48pt;" width="64" height="20">input</td> <td style="width: 48pt;" width="64">output</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt;" height="20">GGGGG</td> <td>GGgGfG</td> </tr> </tbody></table>
I've tried setting the formatting in Find and Replace, but I only get 'Excel cannot find a match' even though I'm staring at a red G. Making sure the font name and font size are explicitly set did not help.
Any suggestions?
thanks