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

  • Thread starter Thread starter dereksmom
  • Start date Start date
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!
 
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
Conditionally formatting entire rows 2
Excel VBA 1
Cells change color when another cell is activated or typed with an 5
Lock cells conditionally formatted in 2007 1
Excel 2007 Problem Paste/Enter Key 0
Automatically color merged cells 1

Back
Top