Hello
I want to make a table in wich the color of an entire row should change depending on the value from the cells from the first column of the table.
I attached an example.
Can this be done?
Conditional formatting
Conditional formatting
- Attachments
-
- row color.ods
- (10.26 KiB) Downloaded 74 times
Open Office 4, Windows 7 Ultimate
Re: Conditional formatting
Select all of the cells you want to affect and go to the menu Format -> Conditional Formatting. In the Conditional Formatting dialog, set the leftmost box to Formula Is and make the formula like
All of the selected cells will then have formatting that depends on the value of B6. The $ in the cell reference make it absolute, so it does not change for each cell.
Code: Select all
$B$6 = "Value 1"
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: Conditional formatting
The "Formula" option is more useful than the comparison operators.
- Attachments
-
- row color2.ods
- conditional formatting
- (13.28 KiB) Downloaded 71 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Conditional formatting
thank you for the tips but if new data will always be added/changed in the "value" column, is your solution still going to work?
Open Office 4, Windows 7 Ultimate
Re: Conditional formatting
did you try? Why not?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Conditional formatting
Thanks Villeroy, but in your example i cannot introduce new values in the first column, so i found this example:
i made a helper column (A) with this forumla: =IF(B7=B6;A6;A6+1)
then, in conditional formatting i introduced 2 conditions:
ISEVEN($A31) - color 1
ISODD($A31) - color 2
this is solved
i made a helper column (A) with this forumla: =IF(B7=B6;A6;A6+1)
then, in conditional formatting i introduced 2 conditions:
ISEVEN($A31) - color 1
ISODD($A31) - color 2
this is solved
- Attachments
-
- row color 3.ods
- (10.84 KiB) Downloaded 56 times
Open Office 4, Windows 7 Ultimate