Formula in conditional formatting

[jaxs2009]

Excel 2007

In conditional formatting New Rule under "Use a formula to determine which cell to format I input

=ROW(C6)=ActiveRow, I then set my range at $C$6:$CG$1000 but it not working in the "SIP" spreadsheet, however it does work in in the same workbook but in spreadsheets "WIP" and "CHANGER ORDERS"

There is a VBA code performing another function of transferring data to another sheet and I do have some other conditional formatting in this spreadsheet but they are single cell functions.

Any thoughts as to why this "SIP" particular sheet it doesn't want to work?

 

[Special-K99]

I wasnt aware you could put "ActiveRow" in a conditional formatting formula.
I've seen named ranges but not a variable like that.

Here's two solutions but they don't use ActiveRow

https://www.thesmallman.com/blog/2016/9/15/auto-highlight-the-active-row-when-a-cell-is-selected
https://trumpexcel.com/highlight-active-row-column-excel/

 

[jaxs2009]

Yes, the VBA code did work as suggested, thank you for the links to another way to achieve this functions. have a great day.