Conditional formatting

[smcelv]

I'm trying to have data in cell A3 supply formatting to cell D3 if a true value is returned.

BUT cell A3's data has 13 characters I need the first 9 characters only to be read.
For example it could read C21167854-002
I need to ignore the 002 as those numbers are prone to change but the C21167854 is relatively constant.

 

[Joe4]

I am not sure what role Conditional Formatting plays in this.
It sounds like you might just really need the LEFT function, i.e.

=LEFT(A3,9)

 

[Asbestos_Jen]

Is this what you're looking for?

Book1
	A	B	C	D	E
1
2
3	C21167854-002			D3	true
4
Sheet1

Cell Formulas
Range	Formula
E3	E3	=IF(LEFT(A3,9)="C21167854","true","false")

 

[Joe4]

Is this what you're looking for?

Book1
	A	B	C	D	E
1
2
3	C21167854-002			D3	true
4
Sheet1

Cell Formulas
Range	Formula
E3	E3	=IF(LEFT(A3,9)="C21167854","true","false")

View attachment 105997

Ah, maybe that is what they are trying to do. It is not quite clear from the question.

By the way, you usually do not need use IF functions in Conditional Formatting formulas. Just create a boolean expression to return TRUE or FALSE.
For example, you could simply your formula to just:

=LEFT(A3,9)="C21167854"

 

[Asbestos_Jen]

@Joe4 Thanks, I thought of that after I posted. The formula can just go straight into conditional formatting, rather than column "E", too, but I wasn't sure what the OP was trying to compare to, so I did it this way.

 

[smcelv]

Is this what you're looking for?

Book1
	A	B	C	D	E
1
2
3	C21167854-002			D3	true
4
Sheet1

Cell Formulas
Range	Formula
E3	E3	=IF(LEFT(A3,9)="C21167854","true","false")

View attachment 105997

Joe that looks exactly what I need. Can't check it just now but pretty sure that's the answer. Thank you very
much for your help!

Is this what you're looking for?

Book1
	A	B	C	D	E
1
2
3	C21167854-002			D3	true
4
Sheet1

Cell Formulas
Range	Formula
E3	E3	=IF(LEFT(A3,9)="C21167854","true","false")

View attachment 105997

Joe that looks exactly what I need. Can't check it just now but pretty sure that's the answer. Thank you very

much for your help!

Is this what you're looking for?

Book1
	A	B	C	D	E
1
2
3	C21167854-002			D3	true
4
Sheet1

Cell Formulas
Range	Formula
E3	E3	=IF(LEFT(A3,9)="C21167854","true","false")

View attachment 105997

 

[smcelv]

Joe that looks exactly what I need. Can't check it just now but pretty sure that's the answer. Thank you very
much for your help!

Joe that looks exactly what I need. Can't check it just now but pretty sure that's the answer. Thank you very

much for your help!

Sorry Jen - Thank you for your help.

 

[Asbestos_Jen]

Thanks for the feedback, I'm glad to help. As @Joe4 said, you can simplify the formula to:

=LEFT(A3,9)="C21167854"

 

[Joe4]

You are welcome.
Glad that we were able to help!