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 ...
Why don't apply the rule to entire range and not copy it from cells to cells?
If to highlight blanks second part of the formula shall be removed.
- 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.
