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

Yes

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

if right("a12345",6) = A2

"franciz" wrote:

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

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

"Joel" wrote:

Yes

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

if right("a12345",6) = A2

"franciz" wrote:

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

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" wrote:

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

"Joel" wrote:

Yes

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

if right("a12345",6) = A2

"franciz" wrote:

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

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" wrote:

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" wrote:

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

"Joel" wrote:

Yes

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

if right("a12345",6) = A2

"franciz" wrote:

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

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.

"franciz" wrote:

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" wrote:

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" wrote:

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

"Joel" wrote:

Yes

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

if right("a12345",6) = A2

"franciz" wrote:

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