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
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