Can I color a cell with "If" formula

's Computer Specifications

I would like to have the cell turn a certain color with an "If", "Then"
formula. Is that possible?

's Computer Specifications

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

's Computer Specifications

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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Referring to "previous cell" in a formula in a "varying current ce	arasan77	Microsoft Excel Programming	2	10th Sep 2009 06:36 PM
Formula Result is "V6", need Excel to use cell "V6", not the resul	Erik	Microsoft Excel Worksheet Functions	3	5th Sep 2008 03:10 PM
cell to change color =IF(B7>53,"Critical","Normal")	=?Utf-8?B?Zmdpb3Jk?=	Microsoft Excel Misc	3	18th Aug 2005 09:57 PM
set "value if true" to "fill cell with color"	=?Utf-8?B?RmVldGE=?=	Microsoft Excel Programming	4	23rd Jul 2005 08:16 AM
How can I make cell A1 a "Y" or "N" depending upon cell A2's font color? Please help.	=?Utf-8?B?amRvdmU3OEB5YWhvby5jb20=?=	Microsoft Excel Programming	1	16th Oct 2003 08:32 PM