Cell background color update
 

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

Cell background color update
 

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

Cell background color update
 

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