Re: [libreoffice-users] Conditional Formatting Borders on cell that contains text

Rob Select 1 cell (just take an arbitrary one) Right click cell and go to “Format cells” Select tab “borders” Click “all for borders” (second from left, square) Click OK Select from toolbar: Styles -> New Style from Selection Name the style in the pop-up box (I named it mybox) Select from

Re: [libreoffice-users] Conditional Formatting Borders on cell that contains text

https://wiki.documentfoundation.org/images/d/d1/LibreOffice_Calc._Conditional_formatting_guide_EN.pdf Il 14/09/23 04:22, Rob Berridge ha scritto: Hi I am trying to shift a file I have in Excel 2021 to LibreOffice calc. In it I have a few Conditional Formatting rules. One is that if the cell

[libreoffice-users] Conditional Formatting Borders on cell that contains text

Hi I am trying to shift a file I have in Excel 2021 to LibreOffice calc. In it I have a few Conditional Formatting rules. One is that if the cell is empty there are no borders, but when there is something in the cell, the range then has borders. I am unsure how to do that in LO Calc .  In

[libreoffice-users] Conditional Formatting Borders on cell that contains text

Hi I am trying to shift a file I have in Excel 2021 to LibreOffice calc. In it I have a few Conditional Formatting rules. One is that if the cell is empty there are no borders, but when there is something in the cell, the range then has borders. I am unsure how to do that in LO Calc .  In

Re: [libreoffice-users] conditional formatting based on day of week

it will hightlight whole row of data instead of just that column. On 28 May 2021 at 18:01, Gary Dale wrote: To: LibreOffice Users From: Gary Dale Subject:[libreoffice-users] conditional formatting based on day of week Date sent

Re: [libreoffice-users] conditional formatting based on day of week

Thanks. I misread the help document on Weekday, and didn't read the ADDRESS help. I initially was using INDIRECT but it wasn't working for the reasons you mentioned. On 2021-05-28 20:29, Brian Barker wrote: At 18:01 28/05/2021 -0400, Gary Dale wrote: It's been years since I tried to do

Re: [libreoffice-users] conditional formatting based on day of week

At 18:01 28/05/2021 -0400, Gary Dale wrote: It's been years since I tried to do anything with conditional formatting and now I can't seem to get it right. I have a spreadsheet sorted in date order where I want to highlight the start of each week (i.e. Sunday) to divide up the data visually. My

[libreoffice-users] conditional formatting based on day of week

It's been years since I tried to do anything with conditional formatting and now I can't seem to get it right. I have a spreadsheet sorted in date order where I want to highlight the start of each week (i.e. Sunday) to divide up the data visually. My idea was to test if the date cell in the

Re: [libreoffice-users] conditional formatting based on day of week

. On 28 May 2021 at 18:01, Gary Dale wrote: To: LibreOffice Users From: Gary Dale Subject:[libreoffice-users] conditional formatting based on day of week Date sent: Fri, 28 May 2021 18:01:38 -0400 > It's been years since I tr

Re: [libreoffice-users] Conditional Formatting Problem After Copy Sheet

Greetings, This is something LO does differently from Excel. When you copy a sheet in Excel that references another sheet, the source sheet used for calculations (like Sheet2!A3) remains the same. However, in LO, the sheet reference is converted in a way similar to copying a formula on a sheet: a

[libreoffice-users] Conditional Formatting Problem After Copy Sheet

Hi, I have created the attached files to manage staff attendance. Each file with the name of the office must have 12 sheets with the name of the month in UPPER CASE. When I copy JANUARY and save it with the name FEBRUARY, in the conditional formatting, in the range E6: AI30 it should leave the

Re: [libreoffice-users] Conditional formatting in Calc: how to find it?

Le 10/01/2018 à 11:51, ptoye a écrit : I have a spreadsheet with some cells with conditional formatting applied. Unfortunately I don't know what formula or style was used. I tried the Format | Condition | Edit option but all I got was this:

[libreoffice-users] Conditional formatting in Calc: how to find it?

I have a spreadsheet with some cells with conditional formatting applied. Unfortunately I don't know what formula or style was used. I tried the Format | Condition | Edit option but all I got was this: The condition

[libreoffice-users] Conditional formatting and named ranges issues.

I've run into a couple of issues using conditional formatting and using conditional formatting with names ranges. 1. I have a range that includes 4 different columns with conditional formatting. Everything is fine. I insert a row to a a new record in its proper place in the order, and it ends

Re: [libreoffice-users] Conditional Formatting On Date [SOLVED]

Original Message From: Brian Barker Date: Mon, 14 Sep 2015 06:15:32 +0100 > At 22:10 13/09/2015 +0200, Dave Barton wrote: >> In Calc I have column with a series of calculated dates (ie. the >> result of a formula). I am looking to find a way of using conditional >> formatting

[libreoffice-users] Conditional Formatting On Date

In Calc I have column with a series of calculated dates (ie. the result of a formula). I am looking to find a way of using conditional formatting to set the background colour (eg. green) for those dates which fall on a Saturday or Sunday (eg. Condition: = WEEKDAY (A2; 2)>5 sets Format: Cell

Re: [libreoffice-users] Conditional Formatting On Date

At 22:10 13/09/2015 +0200, Dave Barton wrote: In Calc I have column with a series of calculated dates (ie. the result of a formula). I am looking to find a way of using conditional formatting to set the background colour (eg. green) for those dates which fall on a Saturday or Sunday (eg.

Re: [libreoffice-users] Conditional formatting question

Hi :) The dynamic methods are more scalable (or just extend a little) and easier to replicate. Also the original question looked like it required a less static approach. With the static approach you need to remember to do 2 actions and try to remember what the reason/rule was for the different

Re: [libreoffice-users] Conditional formatting question

OK, in stead of an dynamic setting I reverted to manual setting (makes the sheet faster too). I set autofilter on the column, selected all rows not empty, and set the background color... Simple and fast. Why do something dynamic if the data is not that dynamic. On 3 jul. 2015, at 21:32,

[libreoffice-users] Conditional formatting question

Hi, I am looking on a way to set the background color of a full row if one specific field in the row has a value. So, if the value is in col C, this would be the result: A B C D E 1 x y 8 p 2 x2 y2 6

Re: [libreoffice-users] Conditional formatting question

At 16:23 03/07/2015 +0200, Rob Jasper wrote: I am looking on a way to set the background color of a full row if one specific field in the row has a value. [Example: C3 = 3.] I looked at conditional formatting but I don't see how to format the complete line based on one value in the line. By

Re: [libreoffice-users] Conditional formatting question

Andreas Brian, thanks, that works great! Now I have another followup question: I already had a formatting for 2 colums where I set the number of digits behind the decimal based on the formula MOD(F2,0.01)=0. This to make a Euro/dfl denomination look like 0.10 and 0.15, while the real old

[libreoffice-users] Conditional formatting in Calc

In a spreadsheet I needed to set the background color in the three cells A1, B1, and C1, depending on the value of B1. Example: If the cell B1 contains A all the 3 cells will be colored. At all other values in B1 nothing happens. In a couple of hours I found a solution, but not in the Help

[libreoffice-users] Conditional Formatting in Calc

How can this be accomplished with LO 4.0.4.2? Cell B1 should be protected UNLESS the leftmost two characters in A1 are 0/ The sheet is protected. A1 is unprotected. B1 is normally protected. I unsuccessfully tried this conditional formatting in B1: Condition: Formula is LEFT(A1,2)=0/ Custom

Re: [libreoffice-users] conditional formatting broken?

Tom Perhaps a bit more detail would be useful can you give us the steps that you are following. The steps below would change the font colour of all selected cells that contains the number 0 to the same as the white background, i.e. they become invisible. * Select cells to conditionally

Re: [libreoffice-users] conditional formatting broken?

Alex, Thanks for that wonderfully detailed and explicit response. I hope it is useful for others, in the future, who may find it through a search of the forum. Unfortunately, to my original request for help, Brian Barker responded, but to ME ONLY. I didn't notice this, and responded to him,

Re: [libreoffice-users] conditional formatting broken?

Hi :) OOops, other Tom, sorry! Regards from Tom :) On 26 March 2014 11:48, Tom Davies tomc...@gmail.com wrote: Hi :) Ahh, i cheat. 1. Select the cell, row, column, area or even entire worksheet. 2. Format - Cells - Number (the 1st tab in the pop-up) 3. In Category down the left-hand

Re: [libreoffice-users] conditional formatting broken?

Hi :) Ahh, i cheat. 1. Select the cell, row, column, area or even entire worksheet. 2. Format - Cells - Number (the 1st tab in the pop-up) 3. In Category down the left-hand side, click on Number 4. tick the box that says Negative numbers red Regards from Tom :) On 26 March 2014 07:56, Alex

Re: [libreoffice-users] conditional formatting broken?

Hi :) +1 but we all have trouble remembering and getting it right all the time. There are so many other cases were Reply all or Group reply feels wrong or might even be really bad. This mailing list used to have it so that it would default to the list and sending off-list (= back-channel) was

Re: [libreoffice-users] conditional formatting broken?

Hi :) I thought it wasn't possible to set the back-ground colour according to a changing value within a cell. I didn't think MS Excel can do it either. For advanced spreadsheeting-fu i would turn to Gnumeric but i didn't think that could do it either! The closest i got was making negative

Re: [libreoffice-users] conditional formatting broken?

At 12:57 25/03/2014 +, Tom Davies wrote: On 23 March 2014 14:22, Tom Cloyd wrote: I'm using LO 4.2.1.1, on Kubuntu Linux 13.10 I just noticed that a big spreadsheet which has a number cells with a background whose color depends on the value of integer in the cell is all wrong. I tried

[libreoffice-users] conditional formatting broken?

I'm using LO 4.2.1.1, on Kubuntu Linux 13.10 I just noticed that a big spreadsheet which has a number cells with a background whose color depends on the value of integer in the cell is all wrong. I tried resetting - recreating - the conditional formatting. It just doesn't do anything. The

Re: [libreoffice-users] Conditional formatting and speed of calc

Many thanks, Jorge and Johnny, increasing memory improved the speed greatly (and displayed some unusual fonts properly). David Lynch On 22 March 2013 03:16, jorge jrodrigue...@cpcecr.com wrote: Hi all I`m not sure but increasing memory in LO: Menu, Tools, Options, Memory or uncheck in

Re: [libreoffice-users] Conditional formatting and speed of calc

Johnny, Thanks for your reply. Further details: 17 sheets about 105000 active cells largest sheet 256 by 112 conditional formatting is on 60 cells and each test is a VLOOKUP on 30 cells. David Lynch On 20 March 2013 16:30, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2013/3/19 david_lynch

Re: [libreoffice-users] Conditional formatting and speed of calc

Hi all I`m not sure but increasing memory in LO: Menu, Tools, Options, Memory or uncheck in spanish: Menu, Herramientas, Contenido de Celdas, Cálculo Automatico y luego usar F9 para recalcular todo. Regards, Jorge Rodríguez El jue, 21-03-2013 a las 19:00 +, david_lynch escribió:

[libreoffice-users] Conditional formatting and speed of calc

I have a large and complex spreadsheet: 17 sheets and 1.4Mb. Normally, it runs acceptably fast (although not at lightning speed). I added conditional formatting to about 80 cells: it then takes about a minute to respond to any input, whether in the cells with conditional formatting or not. Am I

[libreoffice-users] Conditional formatting and speed of calc

I have a large and complex spreadsheet: 17 sheets and 1.4Mb. Normally, it runs acceptably fast (although not at lightning speed). I added conditional formatting to about 80 cells: it then takes about a minute to respond to any input, whether in the cells with conditional formatting or not.

[libreoffice-users] Conditional formatting

Conditional formatting I have a grid of cells selected (approx 48 X 120) these cells have Conditional formatting set on them Enter a letter in any of the cells (say 'r' for red) and that cell will formate to red - I have 4 different colours I can set this up no problem and it works ok But when I

Re: [libreoffice-users] Conditional formatting

Le 07/11/2012 17:44, IGraham a écrit : Conditional formatting [...] W764 LibreOffice 3.6.2.2 You should upgrade to the current release which is 3.6.3. Several bug involving conditional formatting have been fixed in this release. Best regards. JBF -- Seuls des formats ouverts peuvent

[libreoffice-users] Conditional Formatting columns

Hi Conditional Formatting columns Sheet name DH April I have a area/grid of 8 columns E10 to L40, in cell W7 I have a number (1 to 8) I want to starting from the first column (E10) conditionally colour a number of the columns depending upon the number in W7 This is the Conditional Formatting

Re: [libreoffice-users] Conditional formatting cell copying? - SOLVED

Tnx all, The solution was to reference the cells without the $ sign before them. If I copied that cell and selected the cells I wanted to apply the conditional format to, selected Paste Special and selected Formats and Formula, it worked a treat. Thanks to whoever thought of the

Re: [libreoffice-users] Conditional formatting cell copying?

Hi Hylton, Hylton Conacher (ZR1HPC) schrieb: Hi all, Is there a way to copy a particular cells conditional formatting rules across a cell selection either in a row or a column? Yes. Copy a cell, which has the conditional formatting assigned. Mark the target and goto Edit Paste Special.

Re: [libreoffice-users] Conditional formatting cell copying?

Hi Regina, See my earlier reply to Dave in addition to the below:. Copying and writing the conditions are not the problem. Getting the condition to automatically increment is the problem e.g. I have cell A1 that has the formula to add the contents of cells B1, C1 and D1. Cell A1 also has 3

Re: [libreoffice-users] Conditional formatting cell copying?

Hi Hylton, Hylton Conacher (ZR1HPC) schrieb: Hi all, Is there a way to copy a particular cells conditional formatting rules across a cell selection either in a row or a column? I have a spreadsheet with three columns of numbers, two of which require three conditional formatting rules on each