change the color of a cell as a function of the cell value

's Computer Specifications

i would like to know if it is possible to set the color of a cell as a
function of the numeric value within the cell (say red, yellow green) and
then if I change the value have the color automatically update.

Thanks

's Computer Specifications

You can, but i can't be much more specific without details. look into
conditional formatting or post details.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Gary F" wrote:

> i would like to know if it is possible to set the color of a cell as a
> function of the numeric value within the cell (say red, yellow green) and
> then if I change the value have the color automatically update.
>
> Thanks

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using function to change a cell color	Tom	Microsoft Excel Programming	8	25th May 2009 01:21 AM
Function to change cell color	=?Utf-8?B?YWxp?=	Microsoft Excel Worksheet Functions	1	12th Sep 2007 09:14 AM
How do I change the color of a cell depending on the result of the function in that cell	Mo Childs	Microsoft Excel Programming	4	1st Nov 2005 09:30 PM
use if function to change cell color	=?Utf-8?B?YmlnZGFkZHkz?=	Microsoft Excel Worksheet Functions	2	16th Sep 2005 11:36 AM
IF function to change color of cell?	madhatter	Microsoft Excel Worksheet Functions	5	4th Aug 2005 03:27 AM