| 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 |
| 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 | |||
Threaded Mode
