Beatrix
06-05-2017, 10:12 AM
Hi All
I need to write a formula in conditional format which would change the cell references when I copy it down to other cells. I did it before but I can't remember how I did it. Can I use the OFFset function in below formula to achieve that?
I attached a sample test file. Please see J2:J10. When I copy it down the conditional format then the row number in index formula should change as 2,3,4,5... etc.
=IF(INDEX($J$2:$J$10,1,1)=4,IF(AND($C$5=2,$F$2=2),TRUE,FALSE))
Can anyone help me with this please?
Many Thanks
B.
I need to write a formula in conditional format which would change the cell references when I copy it down to other cells. I did it before but I can't remember how I did it. Can I use the OFFset function in below formula to achieve that?
I attached a sample test file. Please see J2:J10. When I copy it down the conditional format then the row number in index formula should change as 2,3,4,5... etc.
=IF(INDEX($J$2:$J$10,1,1)=4,IF(AND($C$5=2,$F$2=2),TRUE,FALSE))
Can anyone help me with this please?
Many Thanks
B.