Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Conditions "duplicated values" and "non duplicated values​​" created for validate existing data only. This works only in the current session and not saved in a file. If you need to store these conditional formats in your workbook, use classical equivalents:

    "duplicated values" => 
COUNTIF (<absolute address of range checked>;<relative address of the current cell>) > 1
    "non duplicated values​​" => 
COUNTIF (<absolute address of range checked>;<relative address of the current cell>) = 1

You can also use the function STYLE(), either alone or in combination with conditional formatting.

Small example - Show how many times duplicated.ods

click to hide/show revision 2
(add alternative solution)

Conditions "duplicated values" and "non duplicated values​​" created for validate existing data only. This works only in the current session and not saved in a file. If you need to store these conditional formats in your workbook, use classical equivalents:

    "duplicated values" => 
COUNTIF (<absolute address of range checked>;<relative address of the current cell>) > 1
    "non duplicated values​​" => 
COUNTIF (<absolute address of range checked>;<relative address of the current cell>) = 1

You can also use the function STYLE(), either alone or in combination with conditional formatting.

Small example - Show how many times duplicated.ods

Eample of alternative solution - Combination of conditional format and STYLE.ods

Conditions "duplicated values" and "non duplicated values​​" created for validate existing data only. This works only in the current session and not saved in a file. If you need to store these conditional formats in your workbook, use classical equivalents:

    "duplicated values" => 
COUNTIF (<absolute address of range checked>;<relative address of the current cell>) > 1
    "non duplicated values​​" => 
COUNTIF (<absolute address of range checked>;<relative address of the current cell>) = 1

You can also use the function STYLE(), either alone or in combination with conditional formatting.

Small example - Show how many times duplicated.ods

Eample Example of alternative solution - Combination of conditional format and STYLE.ods