I want to shade a cell if its contents are 'less than' another cell. The problem is the two cells are alphanumeric. Here's an example.
The cell can contain 7a, 7b, 7c, 6a, 6b or 6c and the cell to comapre it against will contain one of these as well. But I want to shade if the cell is "less than" the other one. Less than here means that 6c is less than 6b, 6b is less than 6a and 6a is less than 7c etc (in other words the order I have shown them above is highest to lowest).
How can I do this in a single conditional statement without having to introduce new fields to assign a numeric value to compare with.
Hope this makes sense.
The cell can contain 7a, 7b, 7c, 6a, 6b or 6c and the cell to comapre it against will contain one of these as well. But I want to shade if the cell is "less than" the other one. Less than here means that 6c is less than 6b, 6b is less than 6a and 6a is less than 7c etc (in other words the order I have shown them above is highest to lowest).
How can I do this in a single conditional statement without having to introduce new fields to assign a numeric value to compare with.
Hope this makes sense.