| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Format? - color if cell is modified by user
I have a VLOOKUP formula (B5) referencing adjacent cell (B4). If the user
chooses to override the value in the default cell (B5) I want the default cell's fill color to turn red. e.g. if user enters "32" into cell B4 (which is an empty cell to begin w/) the VLOOKUP formula in B5 checks another wrkbook and returns the default... say ".09". the user chooses to ignore the default ".09" and enter in ".5" I want the format to automatically change the fill color to red. Any help greatly appreciated. -- JS |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I override conditional format to modify color of 1 cell? | Excel Discussion (Misc queries) | |||
| Conditional format a cell based on color of another | Excel Discussion (Misc queries) | |||
| Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
| Alert user that row has been modified by changing row color | Excel Worksheet Functions | |||
| If a cell is modified after a date; font color change indicate | Excel Worksheet Functions | |||
Threaded Mode
