Select the range of cells. I'll assume it's A1:C500

Formula is: =$C1="x"

Biff

"SystemHack" wrote
in message ...

ok .. problem with this is I have something like 500 rows .. I would
have to sit and enter that for each row individually .. would take
forever. Any shorter ways ?


--
SystemHack
------------------------------------------------------------------------
SystemHack's Profile:
http://www.excelforum.com/member.php...o&userid=26614
View this thread: http://www.excelforum.com/showthread...hreadid=505232