Simple conditional formatting when a cell is rule or consolidation based.
Clients often ask if we can highlight which cells can be entered into and which cannot. Of course we can work around this, but if there is a large table of details (say in a Dynarange) it adds a lot of workings to the sheet.
It would really help if we could format cells based on whether they're rule based or not.
ADMIN RESPONSE
Nov 22, 2024
Thank you for your great idea. While we cannot commit to a specific target version, we will consider adding it to our future internal backlog.
