Making a Cell Turn Color

  • Thread starter Thread starter speedy
  • Start date Start date
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
 
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
 
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.
 
Back
Top