I have 16 fields that all contain conditional formatting. Is there a calculation I could do to identify if conditional formatting was applied to any of those fields?
There is no way to indirectly evaluate the occurrence of conditional formatting. Your calculation would need to be the same as the calculations that were used in the conditional formatting.
Well, it seems kind of self-evidence in that your conditional formatting changes something like the background color or font color. When that style changes, then the conditional formatting has happened. But you could put a button or dot next to it that hides or unhides based on it to tell if it's been applied. I just don't understand where you are going with this and probably because I'm not sure what you're trying to do.
Retrieving data ...