Copying a Conditional Format to other cells...
Closed
Dom
-
26 Mar 2015 à 07:07
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 26 Mar 2015 à 12:12
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 26 Mar 2015 à 12:12
Related:
- Copying a Conditional Format to other cells...
- "Publish your article in rss format for other websites to syndicate" - Guide
- Dvi format - Guide
- Kingston format utility - Download - Storage
- Format usb ubuntu - Guide
- How to format windows 7 - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
26 Mar 2015 à 12:12
26 Mar 2015 à 12:12
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
