Just one sheet refuses to adher to conditional formatting

[eobet1]

I have 5 sheets with the same conditional formatting (honestly, I don’t understand if they’re really shared or sheet specific, the manage pop-up doesn’t really say).

However, on sheet 6 (which is basically a clone of the others), the conditional formatting does not work.

I see no difference between the sheets. When I try to manage the conditional formatting with that sheet selected, it looks exactly the same as other sheets.

If I clear direct formatting, the conditional formatting does not appear.

The only thing I can see is that on the problematic sheet 6 I can’t right-click on a cell to manage the direct formatting like on the other sheets. What else can I look for?

[EarnestAl]

Your conditional formatting is always looking at sheet Räkning1, if the data there is different to that on sheet 6 then you should not expect to get sensible results from the conditional formatting as part of it will be looking at a different sheet.
Do you need to specify the sheet? If not delete the sheet reference.
See the problem here where the second sheet is looking at the data from the first sheet, not the second sheet?
ConditionalRefSheet1CopiedToDifferentSheet.ods (17.7 KB)

[eobet1]

Thanks, but that’s not the issue I’m having. The issue is with the range “T3:T18;A3:A17” which works on all sheets except the problematic one.

[EarnestAl]

Maybe you need to define the range for Sheet6, so in the range enter Sheet6.T3:T18;A3:A18 and OK. It seems to nudge the system into looking at the current sheet although the sheet name is not saved.
See also Erratic Conditional Formatting problem and tdf#126327

[LeroyG]

@eobet1

I can’t right-click on a cell to manage the direct formatting

Could it be a protected sheet?

[eobet1]

No, those protection options look just like all other sheets.

Something I cannot understand either which might help me solve the mystery of the sheet with completely refuses conditional formatting, is that I found that one sheet looks like this when you right-click and choose "manage condition formatting on the left column of cells:

However, on the very same sheet, when you right-click the rightmost column of cells it looks like this (and it doesn’t say “manage”, it just says “conditional formatting”):

Why do I get two different behaviors and different looks for these popups within the very same sheet?

[EarnestAl]

I did manage to to get a condition similar to what you describe. As I said in my earlier comment, I forced the conditional format to look at the current sheet by entering the sheet name in the Range. After OK the sheet name disappeared but the conditional format then looked at the current sheet, not the sheet it was copied from.
I don’t know the sheet name you use for your problematic sheet but if it is Räkning6 then in the Range field enter

@eobet1

Why do I get two different behaviors and different looks for these popups within the very same sheet?

Probably because column A is referenced in all those conditional formats while column S is only represented in one conditional format. Better to click Format > Conditional > Manage and select relevant condition there

[LeroyG]

@eobet1

Why do I get two different behaviors

If do you secondary click on a cell, you will get Manage Conditional Formatting when there are two or more conditions applied to that cell, and Conditional Formatting when there is only one condition applied.

[LeroyG]

@eobet1

I see no difference between the sheets

Can you share a copy of the file to test? Delete all sensible data before. Thanks.

[eobet1]

conditional-issue.ods (12.7 KB)

I’m now convinved that Giem2 and Giem3 for some reason share their conditional formatting formulas, while on the other sheets (which I removed), the conditional formats are local to the sheets.

This is (to me) still not at all apparent in the UI and I do not know how to change it!

[LeroyG]

@eobet1

the conditional formats are local

You can’t manage (at least for what I tested) conditional formatting of another sheet, just of the active.

@eobet1

Giem2 and Giem3 for some reason share their conditional formatting

You can select both sheets, and remove a condition, and it will erase only for the visible sheet. So, the conditions in Giem2 and Giem3 are not shared, but equal.

@eobet1

the sheet with completely refuses conditional formatting

Don’t relay in the context menu to access the conditional formatting.
But the way, your second screenshot (the first in your second comment) shows fragmented ranges, as if you copy and pasted formatted cells/rows.

[EarnestAl]

Giem2 and Giem3 are not identical at all; the ranges are different sizes, the order in the conditional Formats dialogue is different. The order is important for how conditional formatting works when you have overlapping ranges as you have.