HELP - Formula to highlight row if cell contains specific text

[simi_uk]

Hi All,

looking for some help here as i'm going mad trying to get CF to do it for me properly.

I have a single sheet of batch controlled warehouse items & their locations. This sheet is used to track when the main location holding the stock (for example 025E0013A - Rack 23, Shelf E, Bin 13A) becomes empty, when this happens A is removed from the sheet, however I am then left having to search for the secondary bin location (025E0013B) to see if stock is available here.

Can anybody suggest anything that might help? The location column contains all values from 025A0001A thru 025E0065B and 026A0001A thru 026E0065B. What i need it to do is pick out all the bin locations ending with 'B' if the primary 'A' bin is not present - make sense?

Thanks all in advance.

Simi

 

[simi_uk]

Simi - what function does cell A2 perform in your setup ?
You might want to replace references to A2 with J2.

sorry, yes my apologies. i've chaged it now to the code as advised in Glenn's post directly above yours...HOWEVER, i'm still getting issues with some 'A' locations also highlighting....may it be because my full locations actually appear slightly diffently as to those notified previously, i.e. on my sheet they appear as BNSUP0025A0001A thru BNSUP0029E0001B, not 0025A0001A as I have alluded to previously...

 

[Gerald Higgins]

Glenn's suggestion included a specification for the length of the text entries. You'll need to adapt for that.
If you have variable lengths, we'll need to allow for that too. Which is all do-able, but makes it slightly more complicated.