need help
sorry, should be "Formula is"
and not formula "is"
Mangesh
"elz64" wrote in message
...
thank u but ... what 's formula "is" I dont c this. (it's a French
version so names are differents, but I dont have something that's looking
like "is")
"Mangesh Yadav" a écrit dans le message de
...
One way: Use conditional formatting
Go to format conditional formatting. Select formula is and enter the
following in the adjoining box:
=and(len(A1)=10,or(left(A1,2)="01",left(A1,2)="06" ))
Select a format which would be easy to detect, like say a red background
color.
Mangesh
"elz64" wrote in message
...
Hi,
How can I find in a whole sheet a phone number (number starts with
01......
or 06..... and is 10 number long) ?
Is there any means without pure programming?
thank you
|