productsnsa.blogg.se - Openoffice conditional formatting blank cell

Choose Conditional Formatting from the Format menu.

(For this example, I'll assume that you've selected the range A2:A99.)

Select the range you want conditionally formatted.

This works because if the first condition is satisfied (the cell is blank), the second condition is never tested.

The condition that checks for blanks doesn't need to adjust any formatting, but the one that checks for zero values can. The first condition checks for the blanks, and the second checks for zero values. One solution is to apply a conditional format that uses two conditions. There are several different solutions to this predicament. The problem is, if you just add a conditional format that highlights the cells to see if they are zero, then the condition will also highlight any cells that are blank, since they contain a "zero" value, as well. You might want to use a conditional format on the imported information to highlight any zero values.

The information contains numeric values, but it can also contain blanks. Let's say that you routinely import information from another program into Excel.