The GIF file can also be viewed he
http://www.freepgs.com/user/excel.gif

Thanks!!
:-)

Select B2:I4 with B2 as the activecell, do Format=Conditional Formatting

Change Cell Value is to Formula is

enter in the formula

=Countif($B2:$I2,B2)1

then select format and choose font=Red

and OK out.

--
Regards,
Tom Ogilvy


"Sum" <vcswong(at)hotmail.com wrote in message
...
The GIF file can also be viewed he
http://www.freepgs.com/user/excel.gif

Thanks!!
:-)

I tried this method, it works something but not all.
Moreover, I need to do it many times whenever I have 200 rows if I se this
method.
Is there any way to use this method in macro?

Thanks!!

"Tom Ogilvy" wrote in message
...
Select B2:I4 with B2 as the activecell, do Format=Conditional Formatting

Change Cell Value is to Formula is

enter in the formula

=Countif($B2:$I2,B2)1

then select format and choose font=Red

and OK out.

--
Regards,
Tom Ogilvy