hi
use condtional formating.
select a2.
on the menubar...
format conditional formating
formula is.....=$A$2="X"....pick your color.
copy B2 and paste accross the row as far as you want.(whole row?)

regards
FSt1




"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!