How to use conditional formatting in open office

[Romany]

How to use conditional formatting in open office. I am new in open office and had a collection of sale files where I had to determine the low and high sales. How to do that. How to enable that. Also how to color a gridline in the spread sheet. And using the scenarios in the same manner. I need some help in this topic.

[Glenny]

To modify the color of the gridlines you can do this. By evasion, the gridlines in the spreadsheet is grey. If you desire to select an additional color for the gridlines, or wish to create it to some extent darker or lighter, you have to go to the Tools then to the Options then to OpenOffice.org Calc and to the View. Under Gridlines, choose a color from the color drop down box. Click OK.

[JonathanD]

You can identify up to three circumstances for a cell, and then arrange the resultant charges in that cell according to the circumstance. Choose the cell or cells for which you wish to utilize this characteristic, and go to Format and then to the Conditional Formatting. There are three circumstances Obtainable, with a drop down box to modify the three circumstances. This contains a number of operators. The alternative are equal to, less than, greater than, less than or equivalent to, greater than or equal to, not equal to, connecting and not connecting. Choose a condition, and then select a style from the Cell Style drop down menu. There are four evasion styles obtainable.

[Macarenas]

To generate your individual styles, go into a text or integer, to be appropriate the font revolutionize you wish to it, choose the cell, then go to Format and then to the Styles and Formatting or Hit [F11]. In the Styles and Formatting window, hit on the New Style from Selection switch. A window will pop up and ask for the style name. Once this is done, hit on OK. At present, you have to go to Format and then to the Conditional Formatting and in the Cell Style drop down menu, you will see your new style.

[ThoMas321]

Scenarios are a helpful for diminutive characteristic in Calc that permits you to assign a dissimilar set of values to the similar set of cells. This denotes that you can use the formulas and generate charts, as well as use the Data Pilot on the similar cells, with exchange values for dissimilar situations. Choose the cells you desire to enter exchange values to, go to Tools and then to the Scenarios and hit on OK. A grey color box comes into view by evasion approximately the area of selection. This is your Scenario 1. You have to go the Tools and then to the Scenarios to generate the second scenario. At present you can move back and forth connecting the two scenarios using the scenario drop down menu that come into view boxed around the cells. You can generate as several scenarios as you desire to on the similar set of cells.