Cell Colour

's Computer Specifications

Is there a way to change the colour of a cell as part of a formula

ie: =IF(SUM(F5:F8)<>100, change the colour of
cell,IF(SUM(F5:F8)=100,100),SUM(F5:F8))
Thanks for any help I can get

Steve

's Computer Specifications

Use conditional formatting from the format menu. It will allow you to alter
the format of a cell for three different conditions.

Regards...

"Steve" wrote:

> Is there a way to change the colour of a cell as part of a formula
>
> ie: =IF(SUM(F5:F8)<>100, change the colour of
> cell,IF(SUM(F5:F8)=100,100),SUM(F5:F8))
> Thanks for any help I can get
>
> Steve

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can colour of cell shading be fixed to one colour	Tabrez	Microsoft Excel Misc	2	23rd Sep 2008 04:55 PM
BLINK CELL COLOUR OR TEXT COLOUR	K	Microsoft Excel Programming	1	24th Apr 2008 06:57 PM
if cell colour is then change cell colour in range	=?Utf-8?B?dGlnZXI=?=	Microsoft Excel Programming	2	30th May 2007 05:32 AM
change a cell background colour to my own RGB colour requirements	=?Utf-8?B?U3RlcGhlbiBEb3VnaHR5?=	Microsoft Excel Misc	4	16th Jun 2006 01:08 PM
Formatting cell colour based on colour of other cell	=?Utf-8?B?TWFydGE=?=	Microsoft Excel Worksheet Functions	2	16th Jun 2004 05:27 PM