• Formatting
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Colour columns uniformly
Enter a colour code as a 2-digit number xy in row 1 in the respective column:
x = background colour:
0 = white
1 = off-white
y = text colour:
0 = black
1 = brown
2 = red
3 = orange
4 = yellow
5 = green
6 = blue
7 = violet
8 = grey
9 = white
Row separators
Create a highlighted row in column A in the respective row with the following characters for visual
separation:
# or $ = medium grey bar with height 26
= or * = medium grey bar with height 13
-=mediumgreybarwithheight3
!=formattingascommentcolumnwithbluetext
Duplicate recognition
The columns for cable numbers $K, EA assignment $EA1, EA2, reference $REF and LDS text
$LDSTXT are provided with conditional formatting so that duplicates are automatically highlighted.