FIND WITH CONDITIONAL FORMAT

[srizki]

=FIND("5",$A92)>0

I am using this formula but it highlights every number that has 5 in it. I want it to highlight only if the number begins with 5. I tried to use 5* it still did not work, what am I doing wrong.

thanks

 

[barry houdini]

Try

=LEFT($A92)=5

 

[srizki]

Thanks barry,

 

[barry houdini]

..of course, as you may have worked out....that should be

=LEFT($A92)="5"

or

=LEFT($A92)+0=5

 

[vane0326]

ADVERTISEMENT

Do you think this works better. Because he is asking for "5."


=MOD(A6,5)=0

 

[srizki]

Thank you to both of you, but these formula did not work, may be because the string in A1 is text.
here is an example.

415020-Contract Income - Private
540010-Facilities & Admin (F)
411010-Contract & Grant Rev Exchange
411010-Contract & Grant Rev Exchange
411010-Contract & Grant Rev Exchange
411030-Contract Indirect Cost
540010-Facilities & Admin (F)
411010-Contract & Grant Rev Exchange

Thanks

 

[srizki]

I am sorry I did not see the variation in your formula Berry, it worked with ""

Thanks

and Thanks again to both of you