Can I color a cell with "If" formula
in [Functions]
|
Prev: Can I use Sumproduct with the LEFT Function?
Next: Nested IF(OR(AND) Statement with Two AND Conditions
From: DLHedges on 12 Apr 2010 15:12 I would like to have the cell turn a certain color with an "If", "Then" formula. Is that possible?
From: Dave Peterson on 12 Apr 2010 15:18 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 DLHedges wrote: > > I would like to have the cell turn a certain color with an "If", "Then" > formula. Is that possible? -- Dave Peterson
From: JLatham on 12 Apr 2010 15:37
Use Conditional Formatting. It's under Format in the pre-2007 menu, it's in the Home tab, Styles group in 2007. "DLHedges" wrote: > I would like to have the cell turn a certain color with an "If", "Then" > formula. Is that possible? |