Apply conditional formatting to all the cells that you want to change (the
entire row). Use the "Formula is" option in the first box. See Excel's help
documents for how to use the "Formula is" method of conditional formatting.
Best of luck.

Jim

"dereksmom" wrote:

In Excel, how do I set up so that if I enter an "X" on one cell it would
color the entire row a certain color?

Thanks!