Select the cell to change color.

FormatConditional FormattingFormula is:

=cell_with_value=value

e.g. with B13 selected =A1=25

Pick a color from the FormatPatterns 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
wrote:

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


Also, does anyone know of an excel formula book?