Converting a formula to Conditional Format..

[omairhe]

Hello all,

How can I convert =IF(LEFT(A4,1)<>(LEFT(A5,1)),"T","F") into conditional format's custom formula?
If the resulting value is a "T" then apply formatting.

Thanks.

 

[footoo]

Assuming you want to conditionally format the cell containing the formula (let's say B4) :

=B4= "T"

 

[Fluff]

Maybe

=left(A4)<>left(A5)

and select your format

 

[omairhe]

Maybe

=left(A4)<>left(A5)

and select your format

So, no need to give number of characters like this?
=LEFT(A2,1)<>LEFT(A1,1)

 

[omairhe]

Assuming you want to conditionally format the cell containing the formula (let's say B4) :

=B4= "T"

I wanted to put that formula directly in conditional formatting. the cells I'm working with will only have values and no formulas, thus trying to avoid a helper column. I got it all figured out. Thanks to both of you..

 

[Fluff]

Glad we could help & thanks for the feedback