I am using conditional formatting in Excel 2007.
Specifically "Use a formula to determine which cells to format".
I have filled in the dialog "Format values where this formula is true:"
In this dialog it says: =fnCheck_Data(A3,M3)
I am formatting the contents of cell M3 and referencing cell A3.
The problem is when I copy this cell references stay constant.
What I was hoping would happen is these cell references in the formula
adjust to for the cell below the formula would change to:
How can I achieve this? What is correct way to copy the result to multiple
cells so it does what I want?