conditional formatting

[franciz]

Hi

Is it possible to highlight these datas in a sheet using conditional
formatting as :

10000000 as red, and

1234567ab ( there might be 1 or 2 alpha after the numbers) as blue, and
a12345 ( there might be 1 or 2 alpha in front of the numbers as green.

thanks

 

[Joel]

Yes

if left("1234567ab",9) = A1

if right("a12345",6) = A2

 

[franciz]

I am not sure how to use this in conditional formatting in Excel

 

[Joel]

In conditional formating if you change cell Value is to formula is you can
put in a formula like the one below where A1 is the cell you are comparing
against.

=IF( LEFT("1234567ab",9) = A1,TRUE,FALSE)

 

[franciz]

Hi Joel

Thank for looking into this. what I want is that if I have either of these
data in the sheet, comditiomal formatting can do the job for me

10000000 as red, and
1234567ab ( there might be 1 or 2 alpha after the numbers) as blue, and
a12345 ( there might be 1 or 2 alpha in front of the numbers as green.

TIA

 

[Joel]

I was locked out of responding to you since Friday. Not usre why.

You can have up to three independent Conditional Formats for each cell.
Only one show up initially. To add the other two you have to use the add
button on Conditional Formats menu. Each Conditional Format can have a
different color. Press Formats and then Patterns to set the color from the
Conditional Formatt menu.

The conditional format check if the first condition is true and will change
the color if TRUE. If the First condtion is FALSE then it check the second,
and if the second is false then it checks the 3rd.