Forum Discussion
Copying Conditional Formatting with Relative References
I have a spreadsheet that is a training matrix. In Row 7 I have the latest revision dates of each document listed across Row 6. Down the left of the page, I have the associates' names and then their ...
I tried that. Each cell still references the first one, instead of updating to the proper column.
Let play with cell F9. Now it is not highlighted:
After we change the date in it cell becomes red:
Please check the file attached to my previous post.