I think what I'm trying to do is quite straight forward, but I just can't find the right functions or combination of functions to do - partly because some of the obvious functions don't allow wildcards.
I have a column of cells which could contain one of five letters as the first character (P...
How can I get conditional formatting to highlight cells with fractions. Is the only way to get this to separate each number them into different cells?
1/1, 2/2, 13/13 = green
1/2, 5/7, 10/25 = yellow
0/1, 0/8, 0/15 = red