J
JohnG
A number of people can access and update a spreadsheet that I designed for
them. The sheet contains a column with lookup formulas. I need to be able to
quickly scan down the column and see cells where the formulas have been
overwritten with values/text. Is there a way to set this up with conditional
formatting.
My first thought was to use the TYPE function but it does not appear to be
able to identify when the contents of a cell is derived from a formula as
opposed to a simple text string or number.
them. The sheet contains a column with lookup formulas. I need to be able to
quickly scan down the column and see cells where the formulas have been
overwritten with values/text. Is there a way to set this up with conditional
formatting.
My first thought was to use the TYPE function but it does not appear to be
able to identify when the contents of a cell is derived from a formula as
opposed to a simple text string or number.