Maybeand select your formatExcel Formula:=left(A4)<>left(A5)
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..Assuming you want to conditionally format the cell containing the formula (let's say B4) :
=B4= "T"