Conditional format - formula for dynamic solution

[Beatrix]

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.

[Bob Phillips]

Just use


=AND($J2=4,$C$5=2,$F$2=2)

[Beatrix]

Thanks very much xld..It's working perfectly.. Sometimes my thinking process is more complicated than the solution..