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.

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

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