Openoffice conditional formatting other cells
![openoffice conditional formatting other cells openoffice conditional formatting other cells](https://libreofficehelp.com/wp-content/uploads/2020/02/A-Table-of-data-with-empty-cells.jpg)
- OPENOFFICE CONDITIONAL FORMATTING OTHER CELLS MANUAL
- OPENOFFICE CONDITIONAL FORMATTING OTHER CELLS SOFTWARE
- OPENOFFICE CONDITIONAL FORMATTING OTHER CELLS LICENSE
So if anyone can help me, maybe with a total noob brake down of this, I will pay you $1,000,000! Or maybe the 4.1.7 version is different for this, though that makes no sense to me either.Īnyway, I'm fed up trying to figure out what going wrong on my own so now I'm looking for help. I have a feeling I'm missing something very simple, like a bracket or quotation or maybe I'm defining my cell area wrong or something. Almost like I have something overriding it but I'm trying a new sheet each time. Just copy and pasted the whole thing, even named my conditional formatting rule "_highlight" just like his page, and nothing seems to be working. With this one I replicated the exact page that was offered as an attachment by acknak, using the exact same word criteria even. I've even tried what's mentioned at this thread: viewtopic.php?t=30992 and it's not working for me at all. I have tried the above method every way I can think of and I simply cannot get it to work. So if a sell contains "heirloom seeds" or "heirloom veggies" both would highlight under the same conditional formatting rule for the word "heirloom". So I am currently using conditional formatting on a basic spreadsheet to make the cell’s background colour change when the word yes is shown as per the attached document: Conditional formatting example.ods However, I would like the background of the adjacent goal to also turn green when yes is present in cell J2. I want it to work even it the cell contains other words. I want to have conditional formatting for a column (say column a) that will highlight every cell in that column that contains a word (say heirloom) with a specific color (say yellow).
![openoffice conditional formatting other cells openoffice conditional formatting other cells](https://s3.manualzz.com/store/data/029596300_1-fd72dbe65dbda39d4cf6d978f5a273e0-360x466.png)
Ok, I am having the exact same issue as the thread was originally posted for. ' now set color to Odd (number) rows (are even indexes)ĪctRange = actSheet.getCellRangeByPosition(0,i,lCols,i)ĪctRange.New here but been using your suggestions without an account for years and they've all worked flawlessly until this one so I never needed to post. ' set range to one color (performance issue)ĪctRange = actSheet.getCellRangeByPosition(0,lStartRow,lCols,lRows)ĪtPropertyValue("CellBackColor", lEvenColor) ' style heading found: increase start row If INSTR(oCell.CellStyle, "Heading") > 0 then ' watch out on first 4 rows if they might be formatted as heading MsgBox(sQuestion ,35, sModulSubName & " - " & sModulVersion)ĪctSheet = & CHR(10) & "No: apply to actual sheet only" & CHR(10) & "Should all sheets be affected?" _ "Applying alternating background colors to used cell range."_ ' more than 1 sheet, ask if macro should work on all sheets
![openoffice conditional formatting other cells openoffice conditional formatting other cells](https://i.stack.imgur.com/KxLkX.png)
& "Macro " & sModulSubName & " will terminate now." _ & CHR(10) & "range in CALC Documents and will only work there."_
![openoffice conditional formatting other cells openoffice conditional formatting other cells](https://img.brainkart.com/imagebk37/fasNo7O.jpg)
& CHR(10) & "background colors to the rows of the used cell"_ & CHR(10) & "This Macro applies alternating, pre-definied" _ "Macro not called from CALC Document." & CHR(10) _
OPENOFFICE CONDITIONAL FORMATTING OTHER CELLS MANUAL
Sub colorCalcTableRowsEnglish ' manual extension ' =ĭim sModulName, sModulSubName, sModulVersion
OPENOFFICE CONDITIONAL FORMATTING OTHER CELLS SOFTWARE
'this program if not, write to the Free Software Foundation, Inc., 59 Temple
OPENOFFICE CONDITIONAL FORMATTING OTHER CELLS LICENSE
'You should have received a copy of the GNU General Public License along with See the GNU General Public License for more details. 'WARRANTY without even the implied warranty of MERCHANTABILITY or FITNESS FOR 'This program is distributed in the hope that it will be useful, but WITHOUT ANY 'Foundation either version 2 of the License, or (at your option) any later 'the terms of the GNU General Public License as published by the Free Software 'This program is free software you can redistribute it and/or modify it under To apply the same conditional formatting later to other cells: Select one of the cells that has been assigned conditional formatting. See the Help for more information and examples of use. The style must have been defined previously. HTH 'Copyright (c) 2004, 2016 Winfried Rohr, re-Solutions Software Test Engineering 'Cell style' Choose the cell style to be applied if the specified condition matches.