VERY new to calc, and want to do something that should be simple. I have multiple columns of data where I want each column’s cell (after row 1 which is a header) to display next to the number either a red/green up/down arrow based on if that cell’s value is greater or less than the previous cell in that same column (i.e. previous row). Some columns will want a red arrow if increased (and a green arrow if decreased). Other columns will want a green arrow if increased (and a red arrow if decreased). Total newbie here so could use help with the simplest way to do this (I’m assuming it’s a Conditional Format rule of some kind).
The sample, https://help.libreoffice.org/7.5/media/files/scalc/en-GB/conditionalformatting.ods, from Help, Conditional Formatting - All cells, shows you need another column to calculate the difference; either B2-B3 or B3-B2 depending on which way you want your arrows. The numbers in the additional column can be visible or you can colour them white.
If you want to use simple conditional formatting to colour the cells then that can be done with two or three rules.
IconSetConditional.ods (15.7 KB)
2 Likes