Forum Discussion
How can I copy Conditional Formatting on cells below while the formula changes along?
I have made a simple Excel spreadsheet for myself so that I can easily see who I've sent a connection request, who has accepted the request, who I've contacted and who has reacted positively. For eac...
initially I will suggest that you remove the $ sign in reference cell.
I'm sure it is written as $G$2 - make it $G2 --- meaning the column G is absolute while the number (row) will change accordingly.
HTH
I'm sure it is written as $G$2 - make it $G2 --- meaning the column G is absolute while the number (row) will change accordingly.
HTH
Thank you! That already did it for me.