Conditional Formatting (left function) question

glm105

New Member
Joined
Sep 30, 2009
Messages
25
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.:confused:

Thank you,

Giuseppe
 

Misca

Well-known Member
Joined
Aug 12, 2009
Messages
1,559
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.
 

Forum statistics

Threads
1,085,986
Messages
5,387,116
Members
402,044
Latest member
Hidalgo

Some videos you may like

This Week's Hot Topics

Top