Hi,
I have attached a format here that I want my suppliers to fill in while submitting their price quotations. In the format, column C (Quoted Currency) is a drop down list for selecting the currency in which a particular item is being offered. I have used conditional formatting to turn certain cells blue in the row based on the selected currency. I need help to lock all the other cells in a particular row except for the cells in blue (supplier should be blocked from accidentally entering any value except for in the blue cells).
Thanks in advance.
Bookmarks