Hi David:
I do not think you understand what I am attempting to do, so I'll try to clarify what my goal is.
In my spreadsheet cells I have typed a word, e.g., Goes,many times. I meant to type that word in Bold font. Is there a way to change the already typed word (e.g., Goes) to be in bold font by use of the Find & Replace function?
I am not attempting to highlight an area within the spreadsheet. I do not program in vbs, or any other language for that matter. :-) Years ago, I started to learn machine language for the Motorola 6809E chip, but have not ever put what I learned to use.
TNX for your reply. VinceB. On 3/14/2019 11:54 AM, David Belina wrote:
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.
