![]() Otherwise, the cell remains with its predefined formatting. The formula compares if the count is greater than 1 and if so it applies the chosen cell style. The absolute blue range range address is the range where cells are counted if they are equivalent to the red cell address in relative notation (without $ signs). Pick some cell style to be applied when the formula evaluates to True and confirm the dialog. Note the address of the active cell (here: A5) Select the range in question (here: A5:BU542) so you have one highlighted rectangle of cells with one active input cell having the cell cursor. For the hasty casual reader using Apache OpenOffice:
0 Comments
Leave a Reply. |