Making a Cell Turn Color

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

speedy - 12 Jul 2007 03:02 GMT

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

Reply to this Message

T. Valko - 12 Jul 2007 04:05 GMT

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

Signature

Biff
Microsoft Excel MVP

> Hi,
>
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

speedy - 12 Jul 2007 07:24 GMT

>Try this:
>
[quoted text clipped - 4 lines]
>Select the style(s) desired
>OK out

Much obliged.

Reply to this Message

T. Valko - 12 Jul 2007 07:53 GMT

>>Try this:
>>
[quoted text clipped - 6 lines]
>
> Much obliged.

You're welcome!

Signature

Biff
Microsoft Excel MVP

Reply to this Message