Is it possible to do the following:

I want to make a cell change color depending on the value of a different cell.

So for example if A2 = "100" then I want cell A1 to change color.

Please help!

check out FormatConditional Formatting... on the main menu... EXACTLY
what you are looking for...

Good Luck

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=467248

Teddy

Select A1 and FormatCFFormula is =A2=100

Format to a color under FormatPatterns and OK.


Gord Dibben Excel MVP

On Tue, 13 Sep 2005 14:31:47 +0100, TeddyTash
wrote:


Is it possible to do the following:

I want to make a cell change color depending on the value of a
different cell.

So for example if A2 = "100" then I want cell A1 to change color.

Please help!

Cheers Gord,

Worked a treat!!!!

Much appreciated.

~Teddy