I have a lot of data from laboratory results. I get the results with some values like '<0.0005', 0.0001, 0.008, etc. I have a limit I need to test these values against e.g. I want to highlight the cells that have a value >0.5. When I do this, it will also highlight the cells with values of <0.0005. A fix could be changing the <0.0005 to 0 but I don't want that as it is technically wrong. I want a formula that says "if cell is >0.5, and does not contain any text (the symbol "<"), then highlight red". Any suggestions?
Bookmarks