Highlight all the cells
From the Format menu, Conditional Format
Formula Is: =MATCH("Y",1:1, 0)
Pattern: Red

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"jun liu" wrote in message
...
Hi,

I am using excel 2003 in window xp.

what i want to do is: in a row, if a cell is "Y", the whole row will
change to red color. for example:

row shipping item
1 y item1
2 n item2
3 y item3
....

I have more than 500 rows in worksheet. how should i write the code?

thank you,

jun