Hi all, just wondering if there exists a formula that responds to cell formatting?
In other words, say cell A1 is formatted with the cell style “format 1”, and B1 has the formula evaluating A1; is it possible to get B1 to tell me when A1 is formatted with “format 1”? Somethink like =A1=format 1?
It might be better to evaluate on the same condition that made the cell “format 1”.
Yeah I figured as much. It’s just a lot of work I tried to circumvent doing hahaha- my laziness is clearly my downfall in this instance
NEVER use the format properties of the Cells as some data. Use helper cells with flag values.