Cell background color update

[Guest]

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-conditional-formatting-limit.htm

VBA Noob

 

[Guest]

wonderfull, so many thanks