I have Excel 2000. I am trying to shade all the cells in a row if the cell
at the end of that particular row has a value. I can use the conditional
formatting and get that one cell to change shades but I want the whole row to
change. Any help would be appreciated.

Thanks
JM