Use relative cell references in conditional formatting?
Hi all,
Can't quite see how to achieve something here. In a column of numbers, I want to change the text colour in a cell if it's the same value as the cell above. (Basically to "hide" it by changing the text to the same as the background.) It works fine at the top of the column, but when I copy it down the conditional formatting still refers to the top cell rather than simply the one immediately above.
In other words in cell G2, I have conditional formatting to say "if G2 = G1, change text colour) but when I copy the cell contents down the page they all refer back to G1. The actual values are calculated by a formula, and that updates fine using relative cell references as I'd expected, but the conditional formatting doesn't seem to and I can't see how to make it happen.
Kind regards,
Trevor
Can't quite see how to achieve something here. In a column of numbers, I want to change the text colour in a cell if it's the same value as the cell above. (Basically to "hide" it by changing the text to the same as the background.) It works fine at the top of the column, but when I copy it down the conditional formatting still refers to the top cell rather than simply the one immediately above.
In other words in cell G2, I have conditional formatting to say "if G2 = G1, change text colour) but when I copy the cell contents down the page they all refer back to G1. The actual values are calculated by a formula, and that updates fine using relative cell references as I'd expected, but the conditional formatting doesn't seem to and I can't see how to make it happen.
Kind regards,
Trevor
IMac 2010 & iBook G4, Mac OS X (10.6.3)
