Conditional formatting

numaiu · Post by **numaiu** » Sun Jul 15, 2018 2:20 pm

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?

Post by **FJCC** » Sun Jul 15, 2018 2:57 pm

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

Code: Select all

$B$6 = "Value 1"

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.

edit this topic's initial post · Post by **Villeroy** » Sun Jul 15, 2018 3:25 pm

The "Formula" option is more useful than the comparison operators.

numaiu · Post by **numaiu** » Mon Jul 16, 2018 8:32 pm

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?

edit this topic's initial post · Post by **Villeroy** » Mon Jul 16, 2018 9:00 pm

did you try? Why not?

numaiu · Post by **numaiu** » Sat Jul 21, 2018 5:38 pm

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

Conditional formatting

Conditional formatting

Re: Conditional formatting

Re: Conditional formatting

Re: Conditional formatting

Re: Conditional formatting

Re: Conditional formatting