Copying a Conditional Format to other cells...
Closed
Dom
-
Mar 26, 2015 at 07:07 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 26, 2015 at 12:12 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 26, 2015 at 12:12 PM
Related:
- Copying a Conditional Format to other cells...
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- "Publish your article in rss format for other websites to syndicate" ✓ - Office Software Forum
- How to format hp laptop - Guide
- Samsung format code - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Mar 26, 2015 at 12:12 PM
Mar 26, 2015 at 12:12 PM
Hi Dom,
That is because of the $ symbols, they make either column or row absolute.
Try this example for better understanding:
B1: =$A$1
Dragging B1 to the left or the right; the formula remains the same.
B1: =A$1
Dragging B1 to the right will result in =B$1. Column reference is now relative and will change.
Dragging B1 down will result in =A$1. Row reference is still absolute and won't change.
But a better solution would be to use a formula which makes the use of conditional format not necessary:
=IF(AND(A4<>"",A5<>""),A5-A4+1,"")
Best regards,
Trowa
That is because of the $ symbols, they make either column or row absolute.
Try this example for better understanding:
B1: =$A$1
Dragging B1 to the left or the right; the formula remains the same.
B1: =A$1
Dragging B1 to the right will result in =B$1. Column reference is now relative and will change.
Dragging B1 down will result in =A$1. Row reference is still absolute and won't change.
But a better solution would be to use a formula which makes the use of conditional format not necessary:
=IF(AND(A4<>"",A5<>""),A5-A4+1,"")
Best regards,
Trowa
