Copying Conditional Formatting with Formulas Accross Rows
Solved/Closed
Wearrien
Posts
1
Registration date
Wednesday 1 February 2017
Status
Member
Last seen
1 February 2017
-
1 Feb 2017 à 15:43
Wearrien - 2 Feb 2017 à 11:14
Wearrien - 2 Feb 2017 à 11:14
Related:
- Copying Conditional Formatting with Formulas Accross Rows
- Excel clear formatting - Guide
- Little alchemy formulas - Guide
- Excel conditional formatting based on date - Guide
- Protect pdf from copying - Guide
- Excel conditional formatting dates overdue ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
2 Feb 2017 à 10:46
2 Feb 2017 à 10:46
Hi Donna,
That is because you put a dollar symbol in front of the column letter. It will make the column reference absolute, meaning that when you put =$C7 in a cell and drag it to the left/right, it will remain =$C7.
Best regards,
Trowa
That is because you put a dollar symbol in front of the column letter. It will make the column reference absolute, meaning that when you put =$C7 in a cell and drag it to the left/right, it will remain =$C7.
Best regards,
Trowa
2 Feb 2017 à 11:14