32 920
modifications
Modifications
Sauter à la navigation
Sauter à la recherche
Ligne 67 :
Ligne 67 : − + + + + + +
→Detect missing records
[[Fichier:SBK-unexpected-data-61.png]]
[[Fichier:SBK-unexpected-data-61.png]]
This formula should obviously returns 1 when all the rows are available in the file.
This formula should obviously returns 1 all along the column when all the rows are available in the file.
Click a the column header to select it (the D column in this example) then select the "Conditional formatting" tool.
Now, enter a rule that <font color="red">'''highlight the cell'''</font> (in Red) when the '''value is greater than 1'''.
[[Fichier:SBK-unexpected-data-62.png]]
{{SBK-TRAILER}}
{{SBK-TRAILER}}