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!!
:-)