I have a spreadsheet which contains the results of exporting the contents of a DB as a *.csv file.
A small number of the records repeat the value of one field, for example, "companyname" while the other fields contain unique values pertaining to that record. I need to be able to highlight the field when it contains a value repeated in the same field in the record immediately before or after.
This gives a scenario like:
A B C ...
1 0 Foo 4
2 1 Bar 3
3 1 Bar 2
4 0 Not 1
where colA is the flag, colB is the value being tested, and colC represents any other data.
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.
The behavior described above is consistent with my understanding of the documentation.
What have I overlooked?
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
