How to set up so that if I enter an "X" in one cell it would color

D

dereksmom

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

FSt1

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
 
J

Jim Skrydlak

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
 
T

Tim879

Highlight the row(s) you want to format.

Go to Format -> Conditional Formatting

Select formula and enter the following formula assuming you want to
put the X in Column A and are starting with row 1

=$a1="X"
pick whatever color you want

Then whenever you enter an X in column A the row will change color
 
Top