Conditional format, variable rows and columns

[•Daniel•]

Hello I have this formula for conditional formatting to highlight a row:

=AND(OR(COUNTIF($D$5:$F$8,$D5:$F5)>=2),$G5<>0)

If any of the values on the row is reapeatead in the range and another condition is true then highlight the row, the thing is I only know where the range begins, the end column and the end rows are variable, I can store them in variables but don't know how to put the columns variable in:

=AND(OR(COUNTIF($D$5:$[B]F[/B]$" & x & ",$D5:$[B]F[/B]5)>=2),$[B]G[/B]5<>0)

How can I put this "formula1:=" in r1c1 style?,

thx

 

[pbornemeier]

I made a named range (named LX) and use this:
=AND(OR(COUNTIF(INDIRECT("$D$5:$F$" & LX),$D5:$F5)>=2),$G5<>0)

A quick way to get the R1C1 version of a formula is to turn on the macro recorder, click in the cell to edit it, press return.
"=AND(OR(COUNTIF(INDIRECT(""$D$5:$F$"" & LX),R[4]C4:R[4]C6)>=2),R[4]C7<>0)"