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!

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!

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!

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


On May 29, 11:43 am, 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!

Format/ Conditional Formatting/ Formula Is/ =$A2="X"
--
David Biddulph

"dereksmom" wrote in message
...
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!