· I deem my explanation better than others', as I think this one explains the relationships much better (:smug:).
· Applies to both OpenOffice.org Calc and LibreOffice Calc.
This post actually assumes the following:
• That you already have two lists of textual information that you want to compare;
• That you've already created your own custom styles for formatting the necessary cells, but that it's hard to get one's head around about how to do all that comparing.
- Select the column range that you want to format (for example
- From the menu bar choose Format > Conditional Formatting;
- In its window, "Condition 1" is selected by default; below choose "Formula is", and in the next field it gets important,
where insideSo, you have
COUNTIFbrackets you specify the target column (range array) you want to compare the selected column against:
A1:A15selected (which eventually gets formatted) and you want to compare it against
the latter you have to write in array format, with a dollarAfter the semicolon, specify the last cell of the selected range (the one you want to format, not the target range), which is
$sign before every column letter and row number in the range
A15. The whole formula line goes almost exactly like this:
=1means that you apply the format only if there is a match;
=0is inverse: most cells are formatted, those that match are not.
- Don't forget to specify your custom formatting style for cells, then click OK.