conditional format question

H

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
 
J

JE McGimpsey

Harvey Waxman said:
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?
Click to expand...

Try:

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

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
 
H

Harvey Waxman

CyberTaz said:
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"
Click to expand...

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

Harvey Waxman

CyberTaz said:
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
Click to expand...

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