MrExcel Publishing
Your One Stop for Excel Tips & Solutions

recognising values


Posted by Marcus on June 14, 2001 8:21 AM

I am entering trace element test results into a spreadsheet which has conditional formating to change the color of the cell if the value is over the accepted maximum. some of the values are proceeded by a "<" symbol as in "<6.2", is there any way to make excel recognise this as the value "6.2" for the conditional formating but still display "<6.2".
Any help would be much appreciated.
Marcus


Posted by Aladin Akyurek on June 14, 2001 8:27 AM

Assuming that you only have ">", "=", and "<", use the formula option where you enter:

=RIGHT(A1,LEN(A1)-1)+0

Aladin