:banghead: How can I search and replace diagonally, I have a range of 8 Rows by 8 Columns; r10:y17, I want to search each cell in this range , for example we start in r10
if the value of cell(r10,c10)=3 and cell(r11,c11)<0; then replace the value of cell(r11,c11) to be 1.1; where cell(r10,c10) represents cell(row10,column10)
if the value of cell(r10,c10)=3 and cell(r11,c11)= blank and cell(r12,c12)<0 then replace the value of cell(r12,c12) by 1.1
if the value of cell(r10,c10)=3 and cell(r11,c11)= blank and cell(r12,c12)= blank cell(r13,c13)<0 then replace the value of cell(r13,c13) by 1.1
if the value of cell(r10,c10)=3 and cell(r11,c11)= blank, and cell(r12,c12)= blank and cell(r13,c13)= blank , cell(r14,c14)<0 then replace the value of cell(r14,c14) by 1.1
if the value of cell(r10,c10)=3 and cell(r11,c11)= blank, and cell(r12,c12)= blank and cell(r13,c13)= blank , and cell(r14,c14)= blank ,cell(r15,c15)<0 then replace the value of cell(r15,c15) by 1.1
if the value of cell(r10,c10)=3 and cell(r11,c11)= blank, and cell(r12,c12)= blank and cell(r13,c13)= blank , and cell(r14,c14)= blank , and cell(r15,c15)= blank ,cell(r16,c16)<0 then replace the value of cell(r16,c16) by 1.1
if the value of cell(r10,c10)=3 and cell(r11,c11)= blank, and cell(r12,c12)= blank and cell(r13,c13)= blank , and cell(r14,c14)= blank , and cell(r15,c15)= blank , and cell(r16,c16)= blank , cell(r17,c17)<0 then replace the value of cell(r17,c17) by 1.1
Then I want to chick for each cell in the range
thanks for help