I would like to have the cell turn a certain color with an "If", "Then" formula. Is that possible?
D DLHedges Apr 12, 2010 #1 I would like to have the cell turn a certain color with an "If", "Then" formula. Is that possible?
D Dave Peterson Apr 12, 2010 #2 You can't do it with a formula in the cell. But you may be able to do what you want based on conditional formatting. Format|Conditional formatting is where I'd start (xl2003 menus) That, and Debra Dalgleish's site: http://contextures.com/xlCondFormat01.html
You can't do it with a formula in the cell. But you may be able to do what you want based on conditional formatting. Format|Conditional formatting is where I'd start (xl2003 menus) That, and Debra Dalgleish's site: http://contextures.com/xlCondFormat01.html
J JLatham Apr 12, 2010 #3 Use Conditional Formatting. It's under Format in the pre-2007 menu, it's in the Home tab, Styles group in 2007.
Use Conditional Formatting. It's under Format in the pre-2007 menu, it's in the Home tab, Styles group in 2007.
