I would like to highlight/shade a certain cell in whichever row I am
currently working on. For example, whenever I am anywhere on row 10 I would
like cell A10 to be highlighted or shaded a certain colour, and similarly for
row 11 cell A11 etc. I have been looking for a function like ACTIVEROW or
ACTIVECELL so that I can then use conditional formatting, but can't find
anything.
I am using EXCEL 2007.

Please help. Thanks.