Forum Discussion
Conditional formatting
Hi Everyone, First timer here. I am building some spreadsheets and I am having some issues with conditional formatting. The sheet contains results from laboratory water testing and results are ofte...
Use something like this in the conditional formula:
=VALUE(SUBSTITUTE(B3,"<",""))
Basically you're just telling xl to drop the '<' if it's there and treat the result as a number.