Description: If Steps to Reproduce: 1. Create a file with in Sheet1 entries (e.g. A-F) vertical in column A 2. Create sheet2 with some entries in column A 3. Set conditional foor sheet1 to "is Duplicate" for range "A1:A9;$Sheet2:A1:$Sheet2:A100" 4. Save 5. In the popup the range is set to "A1:A9;A1:A100" (ERRONIOUS) 6. The condition works as espected: Cells in Sheet1 with values that occur in sheet 2 are formatted. 7. Save the file Actual Results: Apon re-opening the formatting only works for sheet1 Expected Results: Range should stay as specified Formatting should still be present Reproducible: Always User Profile Reset: No Additional Info: Version: 7.0.4.2 Build ID: dcf040e67528d9187c66b2379df5ea4407429775 CPU threads: 4; OS: Mac OS X 10.15.7; UI render: default; VCL: osx Locale: nl-NL (nl_NL.UTF-8); UI: en-US Calc: threaded
Created attachment 169044 [details] testfile
Created attachment 169045 [details] Screenshot1
Created attachment 169046 [details] Screenshot2
Created attachment 169047 [details] sceenshot3
Screenshot 3 shows the range entered, screenshot2 shows the popup, screenshot 1 shows it is working dispite the wrongly showed range in screenshot 2. Once saved and reloaded the condition works wrongly as shown in screenshot 2.
Conditional format it's only per sheet. You introduce the reference to the other sheet by hand, but after Ok returning to edit, doesn't show the sheet reference. When Ok is when the address it's verified.
(In reply to m.a.riosv from comment #6) > Conditional format it's only per sheet. > > You introduce the reference to the other sheet by hand, but after Ok > returning to edit, doesn't show the sheet reference. When Ok is when the > address it's verified. There is no error message upon entering the range on the other sheet! And, if one enters such a range it does work! You can see this in attachment 1, where duplicates from the other sheet are marked red So, the only thing thatb is missing seems to be the proper storage of the ranges.