P Paul Pruchnik Oct 25, 2004 #1 Greetings, Is there a way to color cell background from within an "IF" statement ? Thanks, -Paul
G Gord Dibben Oct 25, 2004 #3 Paul Not without using Conditional Formatting or VBA. Formulas alone cannot change cell formats. You can place an "IF" statement in CF "formula is" Or perhaps just a "cell value is" in CF would suffice. Gord Dibben Excel MVP
Paul Not without using Conditional Formatting or VBA. Formulas alone cannot change cell formats. You can place an "IF" statement in CF "formula is" Or perhaps just a "cell value is" in CF would suffice. Gord Dibben Excel MVP
D David McRitchie Oct 25, 2004 #4 Hi Paul, For help with Conditional Formatting see http://www.mvps.org/dmcritchie/excel/condfmt.htm The great part is that the formulas are Worksheet Function formulas written to provide either True (not zero), or False (zero) as the result. You are limited to 3 colors (+ default), so if you need more you would need to use an Event macro all described or linked from the above web page.
Hi Paul, For help with Conditional Formatting see http://www.mvps.org/dmcritchie/excel/condfmt.htm The great part is that the formulas are Worksheet Function formulas written to provide either True (not zero), or False (zero) as the result. You are limited to 3 colors (+ default), so if you need more you would need to use an Event macro all described or linked from the above web page.
