G
Guest
Can I conditionally format such that if some one overtypes a cell that has a formula entered, it will trigger the conditional formatting?
Thanks!
Thanks!
J
Jason Morin
Here's one way that I posted about 6 months ago:
http://makeashorterlink.com/?B24152417
HTH
Jason
Atlanta, GA
trigger the conditional formatting?
http://makeashorterlink.com/?B24152417
HTH
Jason
Atlanta, GA
overtypes a cell that has a formula entered, it will-----Original Message-----
Can I conditionally format such that if some one
trigger the conditional formatting?
K
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
trigger the conditional formatting?
circular reference. The best way to do it is to protect
the cells that have formulas in them.
Kevin M
overtypes a cell that has a formula entered, it will-----Original Message-----
Can I conditionally format such that if some one
trigger the conditional formatting?
T
Trip Levert
overtypes a cell that has a formula entered, it will-----Original Message-----
Can I conditionally format such that if some one
trigger the conditional formatting?
to "Data" the "Validation" then choose "input message".Thanks!
.
You can also use data validation from the data menu. Go
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