how to automatically highlight a row?

[Guest]

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 ite
1 y item
2 n item
3 y item
....

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

thank you

jun

 

[Kilo Bravo]

I would just use conditional formating for this.

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:

 

[Rob van Gelder]

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

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: