Making a Cell Turn Color

S

speedy

Hi,

If I input a number in A1, such as 1, and I have the following numbers
in B1 1,2,3 just like that separated by commas.

When I put that 1 in A1, since it matches a number in B1, can I then
have B1 automatically turn red? (or yellow or whatever)

Thanks
 
T

T. Valko

Try this:

Select cell B1
Goto the menu Format>Conditional Formatting
Formula Is: =ISNUMBER(FIND(","&A1&",",","&B1&","))
Click the Format button
Select the style(s) desired
OK out
 
S

speedy

Try this:

Select cell B1
Goto the menu Format>Conditional Formatting
Formula Is: =ISNUMBER(FIND(","&A1&",",","&B1&","))
Click the Format button
Select the style(s) desired
OK out
Click to expand...

Much obliged.
 
Top