Description: When I make a conditional formatting who use cell reference has limit is in other sheet, the conditional formatting is not setup, and can't be see in conditional formatting manage. Steps to Reproduce: 1. Make a sheet with data in to column 2. In a different sheet write in a cell a value who will be used as limit 3. Make conditional formatting in the first sheet with the limit cell as limiter Actual Results: Conditional formatting don't work and not present in management Expected Results: See Conditional formatting in management and working Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0
Created attachment 140420 [details] file-Conditional_formatting
I don't no why you need a second sheet for conditions for another sheet. When using conditional formatting use it in the same sheet. In your case the color did not work, only the number where bold. Setup of your cf is ok, but it could be that there is a link missing> Anyone????
This is a design decision and will not be changed. See Markus's comments in bug 52196 *** This bug has been marked as a duplicate of bug 52196 ***