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