two Conditional formatting

[faizee]

allow to enter value in cell, only if
1. data contain 1 time "x" value between two numeric value . & both numeric values should not be more than 99,
e.g
34x45.5, (allow)......
21x56.44 (allow)
23c45.5, (not allow).
23 x 45.5 (any space not allow)
101x22 (numeric more than 99 not allow)

 

[James006]

Hi,

Are you talking about Conditional Formatting ... or about Data Validation ... ???

 

[faizee]

looking for both options, conditional formatting and data validation..

 

[faizee]

anyone??

 

[shinigamilight]

=NOT(IFERROR(AND(VALUE(REPLACE(B1,SEARCH("x",B1),95,""))<=99,VALUE(REPLACE(B1,1,SEARCH("x",B1),""))<=99,SEARCH("x",B1)>=1,ISERROR(SEARCH(" ",B1))),FALSE))

 

[faizee]

THANK YOU, so much. can we use it in data validation?

 

[faizee]

=NOT(IFERROR(AND(VALUE(REPLACE(B1,SEARCH("x",B1),95,""))<=99,VALUE(REPLACE(B1,1,SEARCH("x",B1),""))<=99,SEARCH("x",B1)>=1,ISERROR(SEARCH(" ",B1))),FALSE))

need opposite of this,
its not allowing required value
but allowing, not required vlaues

 

[shinigamilight]

it's for conditional formatting not for data validation. idk how to do with data validation

 

[faizee]

i just remvod "NOT" formula, now its working perfect. did i do right?

need opposite of this,
its not allowing required value
but allowing, not required vlaues

i

 

[faizee]

it's for conditional formatting not for data validation. idk how to do with data validation

OK, please also add one more condition
also allow if numeric value with inverted commas "
e.g 22"