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

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!

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

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!

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

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!

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

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!

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

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!