How do I create formula to change cell color

[excel formula]

How do I change a cell color if another cell = a certain value?


Also, does anyone know of an excel formula book?

 

[Bob Phillips]

Conditional formatting (Format>Conditional Formatting).

Choose the expression and value you want, and select a colour from the
pattern tab.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Gord Dibben]

Select the cell to change color.

Format>Conditional Formatting>Formula is:

=cell_with_value=value

e.g. with B13 selected =A1=25

Pick a color from the Format>Patterns and OK your way out.

For a book on formulas see Debra Dalgleish's site.

http://www.contextures.on.ca/functions.html for a downloadable workbook.

OR

http://www.contextures.on.ca/xlbooks.html

Gord Dibben Excel MVP

On Wed, 29 Dec 2004 06:47:03 -0800, "excel formula" <excel