| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| What is the macro to change background based on numeric cell value | Excel Worksheet Functions | |||
| function to extract background color from one cell to another | Excel Discussion (Misc queries) | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Linear Mode
