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!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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