The cells in column B all contain a formula, and are protected, such that cells in that column appear blank for all dates in the future, but as they become current a number appears according to the formula in the cell. This number may need to be overwritten.

So once the date in A <= today's date, I want the adjacent cell in B to become unprotected (and change background colour).

Is this possible? I was hoping that I could do it with Conditional Formatting, but I can't figure how to change the format of one cell depending upon the condition of another.