openoffice calc conditional formatting formula

The STYLE() function have an output parameter too. (the passed string = the name of the cellstyle to apply) It will pass one of two string parameters to the STYLE function. You can 'calculate' (select) that string by function (See cellstyles by hit F11 or from menu: Format Styles and Formatting) It have one input parameter: it is a string, the name of a cellstyle to apply. You can use at end of a formula: it will determine the style of the cell (containing the formula). The function STYLE() is an additive function. If there is any reading matter you could point me to, it would be appreciated. I haven't used it but would like to understand it. Ok, no I won't, I'll likely just thank you with capital letters an explanation points or an emoji or two.Re: Style_function.ods you created above. 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'. 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). Ok, I am having the exact same issue as the thread was originally posted for. 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.

Openoffice calc conditional formatting formula