Conditional Formatting

[Steve]

Can I conditionally format such that if some one overtypes a cell that has a formula entered, it will trigger the conditional formatting?

Thanks!

 

[Jason Morin]

Here's one way that I posted about 6 months ago:

http://makeashorterlink.com/?B24152417

HTH
Jason
Atlanta, GA

-----Original Message-----
Can I conditionally format such that if some one

overtypes a cell that has a formula entered, it will
trigger the conditional formatting?

 

[Kevin McClement]

Steve, i don't think that's possible. it would create a
circular reference. The best way to do it is to protect
the cells that have formulas in them.
Kevin M

-----Original Message-----
Can I conditionally format such that if some one

overtypes a cell that has a formula entered, it will
trigger the conditional formatting?

 

[Trip Levert]

-----Original Message-----
Can I conditionally format such that if some one

overtypes a cell that has a formula entered, it will
trigger the conditional formatting?

Thanks!
.
You can also use data validation from the data menu. Go

to "Data" the "Validation" then choose "input message".
You can write a message that will appear when the cell is
selected. It will not prevent the cell from being
overwritten though.

Good Luck!,
Trip