Auto-filling a field if a condition is met
Solved
secutor08
Posted messages
62
Status
Membre
-
via55 Posted messages 14730 Registration date Status Membre Last intervention -
via55 Posted messages 14730 Registration date Status Membre Last intervention -
Hello, is it possible to automatically fill a cell in Excel based on a condition in another cell?
If the condition is not met, the user has to fill in the cell manually, but if the condition is met, the cell fills automatically.
For example, the condition is 10
If the user enters 2, they will also have to fill in the second cell, but if they enter 11, the second cell automatically fills with the value 10.
If the condition is not met, the user has to fill in the cell manually, but if the condition is met, the cell fills automatically.
For example, the condition is 10
If the user enters 2, they will also have to fill in the second cell, but if they enter 11, the second cell automatically fills with the value 10.
2 réponses
Good evening,
of course, it is possible to link the value of one cell to that of another; that is the very principle of a spreadsheet, and we do this with a formula.
For example, the formula in B2: = IF(A1=5; “OK”; “”) will display OK in B2 if we enter the value 5 in A1 and nothing in other cases.
BUT you cannot have both a formula and the ability to manually enter data in the same cell (entering data will overwrite the formula).
Best regards,
--
“Imagination is more important than knowledge.” A. Einstein
of course, it is possible to link the value of one cell to that of another; that is the very principle of a spreadsheet, and we do this with a formula.
For example, the formula in B2: = IF(A1=5; “OK”; “”) will display OK in B2 if we enter the value 5 in A1 and nothing in other cases.
BUT you cannot have both a formula and the ability to manually enter data in the same cell (entering data will overwrite the formula).
Best regards,
--
“Imagination is more important than knowledge.” A. Einstein
Moreover, how to make C3 fill with a color if B2= NO?
It works even if the result in A1 is obtained by formula
For C3, its conditional formatting will be managed by New rule - Use a formula .. and enter the formula
=B2="NO"
If you have difficulties implementing it, post your file on cjoint.com, copy the created link and come back to paste it here clearly stating with a specific example what you are trying to achieve
Best regards
Via