How do I create formula to change cell color
How do I change a cell color if another cell = a certain value?
Also, does anyone know of an excel formula book? |
Conditional formatting (FormatConditional 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) "excel formula" <excel wrote in message ... How do I change a cell color if another cell = a certain value? Also, does anyone know of an excel formula book? |
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? |
All times are GMT +1. The time now is 11:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com