![]() ![]() ![]() Pull down Format -> Conditional Formattingĥ. Take note of the row number of the bottom of your selection (in my example I will use row 7)Ĥ. For example: Suppose the cells in column A either have a string, or are blank. ![]() What Im not sure about is doing it for many cells in such a way that I dont have to format each individual cell. Its also simple enough to conditionally format a single cell based on another single cell. Take note of the letter of the column which you would like to compare the conditional against (in my example I will use Column A)ģ. Conditional formatting a cell is simple enough. Drag from the top left to bottom right so that the active cell in the selection is the last cell of the last row.Ģ. Highlight entire range you'd like to format. Define the condition as follows: If cell value is less than J14, format with cell style Below, and if cell value is greater than or equal to J14. Once you have your styles created ( I will use the examples Green, Yellow, Red1, Red2, Red3 below), you can create unlimited conditional formatting as follows:ġ. There are several ways to do this, the easiest one in my opinion is to style a sample cell the way you want and then create a style from that cell. The Conditional Format function of the LibreOffice Calc can handle MORE THAN 3 conditions. The first step is to create the styles that you want to be able to apply, and name them. The Conditional Format function of the Apache OpenOffice Calc can handle 3 conditions only. I have figured out how to do this, and will put the solution here for future google users so that the title of this thread as "Solved" is actually accurate. Thanks, but "install a different program" is equally unhelpful. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |