Sep 30 2020 04:31 AM
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 this?
Thanks
Jeanne
Sep 30 2020 04:45 AM
Is the font color set manually, or is it based on the value of one or more cells?
Sep 30 2020 05:04 AM
@Hans Vogelaar - it's set manually
Sep 30 2020 07:46 AM
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.
Sep 30 2020 08:10 AM
https://www.extendoffice.com/documents/excel/4136-excel-lock-cell-based-on-color.html
Any articles, templates, third-party products or information I have provided are for reference only. While I endeavor to keep the information up to date and correct as far as I can. I make no representations or warranties, express or implied, as to the completeness, correctness, reliability, suitability, or availability of any product or information, article, file, template, or related graphic on my posts in this forum. The trust you place in such information is therefore entirely at your own risk.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
Sep 30 2020 08:18 AM