I have a column with a "=IF" formula and sometimes users may need to overtype
the result when a "one off" scenario exists. I want to have Conditional
Formatting color the cell whenever the formula overtyped with a manual entry.
I tried the following formula within Conditional Formatting with the type set
to "formula is" versus "cell value is":

=IF(MID(K33,2,3)="IF","false","true")

It doesn't look at the formula within the cell only its resulting value. I
placed the above formula in another cell as a test and of course it came up
false also because it to was analyzing the cell's resulting value and not the
formula within the cell.

Is it possible to Conditional Format against a given Cell's formula and not
it's resulting value? For that matter, can you write a formula in one Cell
that attempts to analyze another Cells formula and not its resulting value.

Any insight would be appreciated - thank you.

Regards,
Mike