Color row based on number in some cell

[alex5730]

Hello,

I have again issues with conditional formatting. I want to apply 3 different formats. Depending on the value in the column “R” I want to color the row from “A” to “J” with

• a red background color when the value in “R” is 1
• a green background color when the value in “R” is 2
• a grey background color when the value in “R” is >4
  I defined three styles (the background color) and added the first rule as follows:

(for rows 2 to 14 to test that rule). But even there are values “1” in column “R”, no row from 2-14 is colored in red. I also tried “$R2==1” but still no coloring of the rows.
What am I doing wrong?

[karolus]

@alex5730

What am I doing wrong?

Nobody knows …
ask_128883.ods (8.2 KB)

[alex5730]

Thanks for the file, seems to be the same in my case. Maybe I need to start a new sheet from scratch. I had similar issues like that before.
Maybe it has to do something with the style?

Oh and the file has multiple tabs.

[sokol92]

@alex5730

Maybe I need to start a new sheet from scratch

I think we can make progress if you upload your file too.

[alex5730]

I cannot upload that file as it contains sensitive information. I just created a new file, and of course it works there. I have to remember that for the future. Seems that bug will be around for a while …

[sokol92]

In such cases, you can leave only those cells filled in that illustrate the essence of the problem. The smaller the uploaded problem file, the faster assistance will be provided (and the less effort required ).