Hi all, My data is in range A1:L10 If cell (A2) value is 1 then range A3:A10 values has to be 1. Likewise for columns B:L Thanks in advance. Ashok