Hi,

You can do that in 2007 but not in 2003. Well in 2003 you probably could
write code to do it, but in 2007 you can use conditional formatting.

Let me know if you want VBA code or if you are using 2007.

--
Cheers,
Shane Devenshire


"akkrug" wrote:

Please let me know if there is any way to use formulas to modify cells that
are populated with drop down boxes from the Data Validation menu. One of our
users now wants to change all cells in a range to N/A if the First cell in
the range contains the value "No".

Thanks for all the help!!

Ken
--
akkrug