Conditional Formatting (left function) question

[glm105]

Hi,

I'm trying to do conditional formating based on the value of another cell. Currently I'm basing it on the first 5 characters in a different cell, as follows.

Forumula is: =left(b10,5)="73214"

Each cell in column b has 10 characters, the first 5 characters are consistent among groups (i.e. all things from group one are 73214*****, from group 2 are 96854*****, etc...)

My issue is that I want to highlight more than 3 groups (excel 03 allows only 3 conditional formatting functions) but with only three colors. For example I want to highlight the groups that start with 73214 and 54897 in yellow.

Is is possible to have a 'left' function that equals more than one thing??

Ex: Something like... =left(b10,5)="73214" OR "54897"

Or does anyone have any ideas of how else to go about this???

I hope I haven't gone into too much detail, please help if anyone knows the answer to this.

Thank you,

Giuseppe

 

[Misca]

To have more than one results try

=OR(LEFT(B10,5)="73214",LEFT(B10,5)="54897")

You should be able to have up to 30 expressions for the OR function in Excel 2003. With 2007 the number has gone up to 255.

 

[glm105]

Misca,

Thanks, this does exactly what I wanted.


Giuseppe