Choose the new formatting that you added, such as Turn Red, and then click OK. Then you should select some formatting for the cells from the Cell Style drop-down list. In the shot below, I have set a condition which will change the formatting of the cell when a number greater than 10 is put in the cells. Then type in a value such as 10 in the text box. Choose a suitable condition from the adjacent drop-down list such as greater than. It is there that you input the conditions for the formatting.Ĭlick on the Condition 1 check-box, and select Cell value is from the drop-down list on the far left of the window. Then click Format > Conditional Formatting to open the window below. Then click OK to save the formatting.Ĭlick a cell, or select a group of cells on the spreadsheet, to add the conditional formatting to. To switch the cell color to red, click the Background tab and then a suitable color from the palette. Then right-click Turn Red, or whatever you added, and select Modify to open the window below.įrom that window you can set up all sorts of conditional cell formatting. That would be suitable if the formatting will turn the cell red. It is there you can add new cell formatting based on a specific condition.Ĭlick on the New Styles from Selection option, and then add a formatting such as Turn Red.
Click on Format and Styles and Formatting to open the window in the shot below. To add conditional formatting to your spreadsheet, you must first set the formatting for a cell. Then that would trigger a change in the background color of the cell where you input the number. For example, a condition could be if you input a number more than, less, than or equal to 10. Among them is a conditional formatting option, which applies certain formatting to cells based on a condition.
#Openoffice conditional formatting by cell containing mac os x#
The freeware OpenOffice spreadsheet application, which you add to your Windows XP, Vista, 7, 8, 8.1, Mac OS X or Linux software library from this website, is one with a variety of formatting options.
0 kommentar(er)
