Can I change the colours on a spreadsheet with an if formula?

's Computer Specifications

's Computer Specifications

If you mean with a cell formula or UDF then No; a function cannot change its
environment, only return a value.
May be you need Conditional Formatting.

NickHK

"Changing Cell Colours with an If formula" <Changing Cell Colours with an If
(E-Mail Removed)> wrote in message
news:7288115B-4A55-4ABF-9894-(E-Mail Removed)...
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
bringing in colours from another spreadsheet	swifts	Microsoft Excel Misc	2	22nd Sep 2009 06:46 PM
Why did text in entered formula change to red in Spreadsheet	=?Utf-8?B?VGFydGFuTWFpZA==?=	Microsoft Excel Worksheet Functions	2	25th Jan 2007 05:17 AM
Cannot Change Formula in Spreadsheet	=?Utf-8?B?bGluZGE=?=	Microsoft Excel Worksheet Functions	1	15th Dec 2006 07:59 PM
is there a formula to auto change cell colours	=?Utf-8?B?YnJlbm5lcg==?=	Microsoft Excel Misc	1	2nd Oct 2006 12:56 PM
Change Year Date In A Formula Throughout The Spreadsheet	=?Utf-8?B?QXV0dW1uIERyZWFtcw==?=	Microsoft Excel Misc	3	3rd Jun 2006 02:12 AM