G Guest Dec 29, 2004 #1 How do I change a cell color if another cell = a certain value? Also, does anyone know of an excel formula book?
How do I change a cell color if another cell = a certain value? Also, does anyone know of an excel formula book?
B Bob Phillips Dec 29, 2004 #2 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)
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)
G Gord Dibben Dec 29, 2004 #3 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
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
