Have a look at Conditional Formatting in Help,
Regards,
Alan.
"kthornton" wrote in message
...
I am tracking RMA's. I have a spreadsheet wher I enter customers
name,product being returned, opened, closed, date, etc.
When I mark an "x" in the cell marked open I want the entire row to shade
in
one color. When I mark "x" in the cell marked closed I want the row to
change color.
How do I accomplish this?