conditional format question

[Harvey Waxman]

If the left three characters of a E3 are ONL format the text color blue.

I wrote this as the formula for the conditional format,

=if(left($E$3,3="ONL"))

Excel says this is wrong. What should it be?

Thanks

 

[JE McGimpsey]

If the left three characters of a E3 are ONL format the text color blue.

I wrote this as the formula for the conditional format,

=if(left($E$3,3="ONL"))

Excel says this is wrong. What should it be?

Try:

CF1: Formula is =LEFT($E$3,3) = "ONL"
Format1: <text>/<blue>

 

[CyberTaz]

Hi Harvey -

Your not taking into consideration that the "IF" is implicit in Conditional
Formatting to begin with, so nesting an additional IF within it is redundant
Try using just: =LEFT(E3,3)="ONL"

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Harvey Waxman]

Hi Harvey -

Your not taking into consideration that the "IF" is implicit in Conditional
Formatting to begin with, so nesting an additional IF within it is redundant
Try using just: =LEFT(E3,3)="ONL"

What a doofus I am. Thanks to you and Murray both

 

[Harvey Waxman]

Hi Harvey -

Your not taking into consideration that the "IF" is implicit in Conditional
Formatting to begin with, so nesting an additional IF within it is redundant
Try using just: =LEFT(E3,3)="ONL"

HTH |:>)
Bob Jones
[MVP] Office:Mac

I wrote a thanks to you but ignored JE McGimpsey. Sorry.