I am using Windows 10, most recent Excel update and I am having trouble sometimes with conditional formatting. I am using rules to turn a cell black if a requirement is met. I have rules that reference a cell value on the current sheet and ones that lookup and reference data on the whole sheet of data for all companies. This problem has only happened with the ones mentioned 2nd.
I have multiple sheets for different companies and I have managed to complete a few of them, so then I am using completed ones to copy and paste into the next ones. I have done about 15 sheets and this has happened on two of the tabs. I have so many sheets to do, that this problem takes up a lot of time.
I first copy and paste the sheet, which does not include any of cond. formatting. I then used the format painter tool for each cell. I have to edit the rules slightly for each sheet.
This is what I got when I formatted the positive cell, which is what it should be.
I then go to change the negative one, and as you can see in the rule preview, it is a different formula which is what it should be.
But then when I click on the rule to edit it, it is suddenly the formula from the other cell. The cells are not linked in any way and this happens randomly so I don't know what is wrong. When this does happen, it also happens to the cells under Operational Indicators and Conclusion. It shows the same formula as in the positive cell.