Hi guys,
Thanks for a great forum.
I'm working on a spreadsheet in which I have a lot of "pairs" of rows like this:
1 (Target): ValueA ValueB ValueC etc etc
2 (Actual): ValueA ValueB ValueC etc etc
I want a conditional formatting of the "Actual" row cells based on the value of the cells above in the "Target" row. E.g.
If A$2 > A$1 --> Green
If A$2 = A$1 --> Yellow
If A$2 < A$1 --> Red
I use $ to lock the row, but obmit it for the columns.
PROBLEM: I want to copy the formatting to a LOT of cells while making sure the references change so that the formatting is always based on the cell directly above the cell in question. However, when I copy the formatting (e.g. with copy/paste special (formatting)) it keeps referencing back to the initial cell.
How do I code a conditional formatting so that I can just copy/paste the formatting to a lot of other cells while ensuring that the reference cell changes to match the cell directly above the cell with the formatting?
I'm sorry if it sounds confusing
Thank you in advance,
Christian
Bookmarks