Suppose you enter the number 5 in A1 cell.
I want excel to disable entry (or fill them with a color) in cells A2,A3,A4,A5.
If you enter number 2 in A1 cell.
I want excel to disable entry in cell A2.
Get the picture ? How can i do that ?
Suppose you enter the number 5 in A1 cell.
I want excel to disable entry (or fill them with a color) in cells A2,A3,A4,A5.
If you enter number 2 in A1 cell.
I want excel to disable entry in cell A2.
Get the picture ? How can i do that ?
Use Data Validation, Custom, in cell A2 using this formulaIf you enter number 2 in A1 cell.
I want excel to disable entry in cell A2.
=ISBLANK(A1)
or
=LEN(A1)=0
To color cells based on the value of another cell see this link on
Excel Conditional Formatting Based on another cell
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks