search through a list with 2 conditions

Hi everybody,

I would like someone's help with this issue please...

I would like a piece of code that searches through column B of my worksheet for a specific word (e.g. "Platform") and when it finds it to check whether the text is in a white font. If it is white text then it should return a positive result, but if it is false then it should carry on looking.

If anyone can help me then this would be much appreciated.

Thanks in advance,

Alex

Alex - what do you mean by positive/negative. Do you want something to happen when it finds a positive result?

yes, sorry, my wording was rubbish! All i basically mean is that the cell is checked and if both conditions are met then that cell is selected.

Thanks!

Still doesn't sound terribly helpful, but try this:

Please Login or Register  to view this content.

Thanks Stephen, this does exactly what i was looking for!