Background colors in cells automatically

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

Is it possible to have Excel automatically apply
background color to a range of cells based upon the
contents of a given cell?

For example, if the contents of cell A1 = "1",
automatically make the background color of A1 green,
otherwise make it red.

If that can be done, can you also make additional cells
have the same background color? For example, if A1 = "1",
color A1 through A5 green, otherwise make A1 through A5 be
red.

Thanks.
 
Ray said:
Is it possible to have Excel automatically apply
background color to a range of cells based upon the
contents of a given cell?
Click to expand...

Yes. Conditional formatting on the Format menu.
For example, if the contents of cell A1 = "1",
automatically make the background color of A1 green,
otherwise make it red.
Click to expand...

Select A1.
Format it ordinarily as red. Then use
Format > Conditional Formatting
Type 1 in the "Cell Value Is" box
Press Format and select green.
OK twice.
If that can be done, can you also make additional cells
have the same background color? For example, if A1 = "1",
color A1 through A5 green, otherwise make A1 through A5 be
red.
Click to expand...

Select A1:A5.
Format ordinarily as red. Then use
Format > Conditional Formatting
Change first box from "Cell Value Is" to "Formula Is".
In formula box type
=($A$1=1)
Press Format and select green.
OK twice.
 
Paul,

Thank you! It works great.

Ray
-----Original Message-----


Yes. Conditional formatting on the Format menu.


Select A1.
Format it ordinarily as red. Then use
Format > Conditional Formatting
Type 1 in the "Cell Value Is" box
Press Format and select green.
OK twice.


Select A1:A5.
Format ordinarily as red. Then use
Format > Conditional Formatting
Change first box from "Cell Value Is" to "Formula Is".
In formula box type
=($A$1=1)
Press Format and select green.
OK twice.


.
Click to expand...
 
Back
Top