Cell background color update

[SalamElias]

Hi, I havnt done Excel programming since Excel 5. Is it possible (using
functions) to auto change the background color of a cell according to a value
in another cell. Lets say if C4 cell = 1, then cell D4 is red, otherwise blue
using an if as follows "IF(C4=1, Red, Blue)
I don't want to use macros. If I should use a Macro, how I can update
automatically without the need to a buton click.
Thanks

[VBA Noob]

Conditional formatting can handle 3 conditions.

Just go to Format > Conditional formatting

Otherwise it's VBA code

See attached for more info

http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm

VBA Noob

[SalamElias]

wonderfull, so many thanks

"VBA Noob" wrote:

>
> Conditional formatting can handle 3 conditions.
>
> Just go to Format > Conditional formatting
>
> Otherwise it's VBA code
>
> See attached for more info
>
> http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm
>
> VBA Noob
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=566383
>
>