But it sounds like it would fix your problem.

With A1 the activecell
format|conditional formatting
formula is:
=left(a1,1)="1"
Format for the first grade

Add a rule and formatting for the 2nd, then the third.

By using =Left(), you only need to worry about that first character.


James E Middleton wrote:

Looks like this is a reply to a different question...

"JMay" wrote in message
...
Pete, Just an FYI..
You say Roger "missed something", not sure but maybe you thought
it might be the 2nd parameter of the Left() function.. (anyway)

By Default if no 2nd parameter is given, 1 is assumed. Try it

In B1 enter:
=Left(A1)

HTH,
Jim

"Pete_UK" wrote in message
ups.com:

Roger missed something from the LEFT functions - try this:

=IF(LEFT(A1,1)="B",1,IF(LEFT(A1,1)="A",2,IF(LEFT(A 1,1)="G",3,"")))

or, if you are likely to have A levels as well as AS in the futu

=IF(LEFT(A1,1)="B",1,IF(LEFT(A1,2)="AS",2,IF(LEFT( A1,1)="G",3,"")))

Hope this helps.

Pete


sike11 via OfficeKB.com wrote:

Hi Roger,

Thanks for the help!
I tried this but it gave me an error "#VALUE". Any other ideas?

Regards,

Mary

Roger Govier wrote:
Hi

Rather than having to type the whole description of what is in cell
A1,
you could just use the first character as in the formula below
Enter in A2
=IF(LEFT(A1)="B",1,IF(LEFT(A1="A",2,IF(LEFT(A1)=" G",3,"")))

Hi All,

[quoted text clipped - 23 lines]

Mary.

--
Message posted via http://www.officekb.com


--

Dave Peterson