Conditional Formatting using LEFT in formula

[leigh3980]

Hi all,
I have mixed character data in cells in the format 60A, 70B, 80C. I want to add some conditional formatting to highlight the cells depending on the value of the numerics in the cell, which are always the first 2 characters. The range of data is C2 : AZ56. I have tried using =LEFT($C2,2)>70 but it highlighted all the cells including the ones less than 70. I have included a spreadsheet with example data.

Any help with this would be greatly appreciated.

thanks

Leigh

[Bo_Ry]

Please try

=--LEFT(C2,2)>70

[leigh3980]

Hi Bo-Ry,
worked perfectly, thank you!! why does it need the "--" in front of the "LEFT"?

thanks

Leigh

[Bo_Ry]

--"70" change text to number 70

[leigh3980]

Awesome, thanks for the information.
regards

Leigh