pasobbrooklyn.blogg.se

• #Openoffice conditional formatting greater than less than how to#

To make things easy if the person enters "0" that means they are not bringing a guest (the employee, however, IS required to come) and if they enter "1" that means they are which means that employee equals two attendees. We'll do a simple spreadsheet that deals with how many persons each employee will bring to a company picnic. The first example will illustrate a basic IF/ELSE statement that uses only two columns of data.

Let's start out with a more simple example and move on to a more complex example. IF entry A is greater than B THEN C is X ELSE C is Y.īut how does one do this? It's actually quite easy. That third columns' entry will depend upon the information in the first two. Let's say you have two columns of numbers and you want to add a third column based on the other two data.

#Openoffice conditional formatting greater than less than how to#

For instance, did you know that Calc can do If/Else statements? In this spreadsheet tutorial you will learn how to use IF/ELSE statements in OpenOffice Calc. Openoffice Calc holds a lot more bang for the users' buck than you might think. Most people know the ins and outs of spreadsheets, but many don't realize just how powerful spreadsheets can be. Find out how Conditional Formatting in MS Excel can make your work effectively without having to sit for hours just for highlighting data to match criteria. Select Condition 1, choose cell value is greater than and type 50 in the value box. Conditional formatting dialog box appears as shown in Figure 11.2. Choose Format Conditional Formatting from the menu bar. The conditional formatting is just applied based on whether your logic. It doesnt matter which of those comparison operators you use. It can be text, dates, or other data types as well. If C1 is greater than A1, I want C1 to automatically color to green background with green text.

In the case below, I want to compare Column A1 to Column C1. I want to apply conditional formatting to an entire column based on a corresponding column value.

And when I work in spreadsheets I work in OpenOffice. Table 11.1 Data with conditional Formatting.