Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto/coditional format
I have the following sheet: Column A = value inserted by user Column B = value inserted by user Column C uses index function using column A + B to return a formula The next 5 columns (D-H) will have additional values, when filling out the form these cells will be empty and will be inserted by the user. My goal is that excel automatically gives the cell a shade/color/marking etc when a value needs to be added. Example: Column C =(D12+E12)/3 * F12 -- I want Excel to shade cells D12,E12 and F12 =(D13*3.14)/G13 *H13 -- I want Excel to shade cells D13,G13 and H13 Now it is easy to see which cells require a value to be inserted by the user or when a value is missing. Is this possible with conditional formatting using a formula? Or do I need to use VBA :( (don’t have any knowledge of VBA). It should be possible; I mean the trace precedents tool shows you all cells used in a formula/cell. Thanks, Willem -- willemeulen ------------------------------------------------------------------------ willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=93723 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
coditional Page Break | Excel Worksheet Functions | |||
Coditional Format | Excel Discussion (Misc queries) | |||
Coditional Formatting? | Excel Discussion (Misc queries) | |||
Why is coditional formatting not accessable? | Excel Worksheet Functions | |||
coditional formatting | Excel Worksheet Functions |