Conditional formatting using numbers, symbols and string/text

I have cells that contain random numbers and I have a conditional formatting set up to say if a cell equals 5 for example make that cell the colour blue.
However I some times have to add for example 5 - MD or 5 + MD the letters could be any combination in the alphabet. so some cells I might have just 5 and some I might have 5 - MD and wanting to have these cells the same shade of blue.

At the moment I am just doing this manually, and the shade are not matching up.

Thanks so much for you help in advance

Originally Posted by Crooza

Try this rule (it will need to be a rule based on a formula when you set it up)

=ISNUMBER(FIND("5",A1))

Thanks that worked great! however i need this to
Work across multiple rows and columns is there
A formula for that? Cheers

Hi,

I tried doing this: =ISNUMBER(FIND("5",A1:L17))

is this correct as it didn't work.

Thanks!

I just saw your screen shots I will try it again

You beauty - I just tried it again - perfect - Thanks!

Hi, sorry but I am having issues again.

I am actually using this formula on a formatted spreadsheet that already has conditional formats in there, so i am going in to edit them. The spreadsheet also already has greyed out sections
where there are no numbers.

When i try to edit existing conditional formats it does not work, also when I clear the spreadsheet form all formulas it still does not work, any ideas?

Thanks!

For some reason it won't let me attach, I've tried the paper clip icon and I have tried dragging it across.

Please see attached