The way the data is displayed in any spreadsheet is determined by the formatting which is linked to cell/row/column and not the particular data. The search and replace function searches the data not the format.
You might be able to write a script (in excel you do this in vbs (visual basic) but I’m not sure in OO. The question is what you want to highlight. If it is a summary or other function you eventually want to arrive at - you can just format the last result cell. On March 14, 2019 at 9:24:27 AM, WA.TWORSX via AOL (wa.two...@verizon.net.invalid) wrote: AOO415m1(Build:9789) - Rev. 1817496 2017-12-11 17:25 Desktop Windows 10-64 Home ________________________________________ I am trying to change the attributes on data that exists within an AOO Calc cell when using the Find & Replace function. For example, if the cell presently shows: Goes I want it to be replaced with: * Goes* That is, add the *bold* attribute to the existing data. In the Find & Replace dialogue window, I have selected: Fewer Options, with none of the boxes checked. I have also selected: Search in: "Values" (near the bottom of that window). ** Is there a way to change / replace the assigned attributes when using Find & Replace function in AOO-Calc Spreadsheets? Regards, VinceB.
