Can I apply conditional formatting from one sheet to the rest in a doc?

[Remina]

Basically, I have a document where the first sheet has a list of story titles (some of which have been published in more than one collection), and the others are collections where those stories are included. I applied conditional formatting in the first sheet so that when I write a specific symbol in column B (this serves the same purpose of a checkbox, I just like it more visually), the name in column C gets strike through. What I want to know is if it’s possible to make it so that title gets strike through in every collection that includes it by writing the symbol only in sheet1 instead of having to do it in every sheet one by one.

Thanks in advance.

[sokol92]

I think if you attach a small example file, we will find something suitable.

[Remina]

Something like this? I made it so when I write a “X” in column B in the All Stories sheet, the title in column C gets strikethrough. What I want is that if I write the “X” next to “Story 1” in All Stories, it gets strikethrough everywhere it’s in, so in All Stories, Collection 1 and Collection 3 in this case
Example.ods (18.6 KB)
.

[PKG]

Example (1).ods (42,1 KB)

[fpy]

@Remina

every sheet

you’ll have to setup with STYLE function
something like : Setting Cell Style either with formula or conditional Formatting! - #4 by PYS

[karolus]

Hallo

1. setup sheet »Collection 1« with all the bells an jingles but without content
2. clone this sheet…
3. write Content

see attached file with 2 Named_Ranges in »All Storys« and CF created in »Collection 1« and cloned to the following Sheets.
the Rule for CF:

Formula is:   ISNUMBER(MATCH("X|"&$C5;xxxx&"|"&titles;0))
⇒⇒ Style: »Strikethrough«

ask_113236.ods (24.3 KB)