Conditional Formatting: Excel not recognizing "1-" and "1+" as numbers.

1- and 1+ is entered as text so using as a straight number maybe difficult
you could use
=VALUE(LEFT(a2,1))
assuming the grades are in column A starting at row 2
to change to a number
then what are you doing ?

otherwise attach a sample spreadsheet

Thanks for the input etaf - I'll try using =VALUE(LEFT(a2,1))

I've attached the spreadsheet to this post.

dont understand the spreadsheet - I would need some easy clarification on what cells you are using and output required
it will take me quite some time to go through and understand all that spreadsheet , and most probably it is not necessary or needed to know all the detail to answer the question for the part you need

can you give a simple sample and explain further what you are doing ?
i dont see 1+ or 1- 1-, 1, 1+, 2-, 2, 2+, 3-, 3, 3+ . (Bl3 ???)

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below.

As mentioned above, a much simplified version of the spreadsheet for testing purposes would be appreciated.

i have just used a simple sheet with 2 values and 2 conditional formatting colours to show how to do it
hope that helps

it does use the formula I suggested - But changed to use =

=VALUE(LEFT(F6,1))= 1

=VALUE(LEFT(F6,1))= 2
etc
and colour for each rule in conditional formatting

so you can colour a 1+ and a 1- the same colour
same for
2+ and 2-
is that what you need?