# FIND WITH CONDITIONAL FORMAT

#### srizki

##### Well-known Member
=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

### Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Try

=LEFT(\$A92)=5

Thanks barry,

#### barry houdini

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

=LEFT(\$A92)="5"

or

=LEFT(\$A92)+0=5

#### vane0326

##### Well-known Member
Do you think this works better. Because he is asking for "5."

=MOD(A6,5)=0

#### srizki

##### Well-known Member
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
411010-Contract & Grant Rev Exchange
411010-Contract & Grant Rev Exchange
411010-Contract & Grant Rev Exchange
411030-Contract Indirect Cost
411010-Contract & Grant Rev Exchange

Thanks

#### srizki

##### Well-known Member
I am sorry I did not see the variation in your formula Berry, it worked with ""

Thanks

and Thanks again to both of you

Replies
2
Views
75
Replies
13
Views
401
Replies
7
Views
149
Replies
2
Views
210
Replies
6
Views
182

1,195,632
Messages
6,010,807
Members
441,569
Latest member
PeggyLee

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back