Restrict values in 1 column

[kathleenfarber]

Hi,

I am trying to restrict values in column D if column G has an entry of 1 and vice versa. I don't think Data Validation will work. Any ideas? Example is if they choose full service in Units A they are unable to choose Units B and vice versa. Any help appreciated.

	ANNUAL FEE	UNITS A	COST	ANNUAL FEE	UNITS B	COST
NSCLC	$100.00		( auto computes )	$60.00		(auto computes)
Late IO	$500.00		( auto computes )	$500.00		( auto computes )

 

[kathleenfarber]

Ever since a windows update, I've had nothing but issues. I'm sending it out to the sales team now and going to have them test it again. Thanks for checking it.

 

[mumps]

Keep us posted.