Forum Discussion
Unlock cells based on the color of text
Hi, I am trying to see if this is possible at all. I have some text in column B that is red, if so, I need the cells in columns C to Z to be unlocked. Is this possible and if so, how could I do th...
Is the font color set manually, or is it based on the value of one or more cells?
HansVogelaar - it's set manually
Then it will be hard, if not impossible, to have Excel do this automatically. There is no event that fires when you change the text color or fill color of a cell.