Making a cell required based on specific input in another cell

[JillOfAllTrades]

Well I am posting this again but I am guessing that nobody in the Adobe forum world knows the answer to my question.  Maybe LiveCycle can't do this....

I have a table with 6 columns and 3 rows. 1 row equals 1 record of data.   Not all the cells within each row are required to make a complete record of data. Staff cannot remember all the whne's and why's for each cell's data so I want to make the form interactive. If they enter specific data into one field then I want the required fields to highlight in RED.

Example:

If staff enter a code that begins with a "3" into the CODE cell, then I need the Location, DUp Svc, & SS cells within the same row to turn RED. I know this is basic but I am stumped and cannot locate an answer that is helping me at this moment.  Any help - GREATLY APPRECIATED!!!

Name	CODE	Location	Time	Dup Svc	SS
Joe	300
Sarah	301
Jenny	359

[whyisthisme]

In the exit event of the code field you would put (in formcalc):

if (Left($,1) == 3) then

[name of your location cell].validate.nullTest = "error"

[name of your DUp Svc cell].validate.nullTest = "error"

[name of yourSS cell].validate.nullTest = "error"

endif

then you would put in the location etc cells in the exit event (also in formcalc)

if ($.isNull == 0) then

$.validate.nullTest = "disabled"

endif