guamlet
Board Regular
- Joined
- Dec 29, 2002
- Messages
- 145
I've used something similar to the following formula (reality is these values come from different worksheets) to get some data to appear as the "average +/- standard deviation, n="
=C3 & " +/-" & D4 & ", n=" & E4
Now I would like to go through the result, look at the first three characters, and if they are greater than a number, change the color of the cell. I tried using Left(Cell(i,j),3), but that only returns strings. So then I tried CDbl to convert the string to a number, which worked great until I encountered areas of the spreadsheet that had actual text like "Muscle". These became numbers like 1.1 or 1.8 when converted to the Double format.
Any ideas on how to make this work?
=C3 & " +/-" & D4 & ", n=" & E4
Now I would like to go through the result, look at the first three characters, and if they are greater than a number, change the color of the cell. I tried using Left(Cell(i,j),3), but that only returns strings. So then I tried CDbl to convert the string to a number, which worked great until I encountered areas of the spreadsheet that had actual text like "Muscle". These became numbers like 1.1 or 1.8 when converted to the Double format.
Any ideas on how to make this work?