Copying Conditional Formatting with Formulas Accross Rows
Solved/Closed
Wearrien
Posts
1
Registration date
Wednesday February 1, 2017
Status
Member
Last seen
February 1, 2017
-
Feb 1, 2017 at 03:43 PM
Wearrien - Feb 2, 2017 at 11:14 AM
Wearrien - Feb 2, 2017 at 11:14 AM
Related:
- Copying Conditional Formatting with Formulas Accross Rows
- Little alchemy formulas - Guide
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- How to clear formatting in excel - Guide
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 2, 2017 at 10:46 AM
Feb 2, 2017 at 10:46 AM
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
Feb 2, 2017 at 11:14 AM