Doug Thompson wrote:
The problem I'm having is that the address of the cell being tested
(flag) for Conditional Formatting doesn't change relative to the cell
being formatted when the formatting is copied. Thus, a test in B1 when
copied to B2 still evaluates cell A1. What I'm trying to find is a way
to have the address of the cell being tested behave like the addresses
when entering a formula in a cell. In other words, a test in B1
dependent upon A1 when copied to B2 would point to A2, and so on.
Just use relative references (without the "$" characters).
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
