There is a formula called CELL, but its not very helpfull in the real world.

Personally if it was a repetative task and fairly limited criteria i would write a macro to check each cell and provide output if not as expected