I'd like to apply a conditional formatting to a range of cells, such that any cells containing a reference (=A5, say) are formatted one way and any containing a typed-in value (probably text, but possibly numerical) are formatted in another way. This is an attempt to build in a low-level audit function. Can it be done?
Bookmarks