Condition formatting problem

  • Thread starter Thread starter Fred's
  • Start date Start date
F

Fred's

Hello all,

I have made a condition formatting if in cell i4 I write for ex.
256324 the row from A4 to H4 turn in color green. my formula is
Formula is =$I$4

my problem is that instead of writting 256324 if I write EL 256324
the condition formatting dosen't work, so my question is what will be
my condition in this case?

Please help!

Thank you.
 
I am a bit confused by your statement "my formula is Formula is =$I$4
Do you mean the cells A4:H4 changes colour when equal to what is in I4?

Now you want, for example, A4 to change colour when A4 is EL 256324 and I4
is just 256324?
If so, try =ISNUMBER(FIND($I$4,A4))
 
I mean that cells A4:H4 changes colour when equal to what is in I4 if
this equal to numbers, but If I enter letter and number in the cell I4
the color dosen't changed
 
Then we replace the arguments: =ISNUMBER(FIND(A4, $I$4))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I mean that cells A4:H4 changes colour when equal to what is in I4 if
this equal to numbers, but If I enter letter and number in the cell I4
the color dosen't changed
 
Back
Top