Geek asks and answers

Force a user to enter a value in a cell based on a different cell value

I am currently working on the following Excel workbook, which will be used to record test cases: enter image description here

If the user enters in felcolumn F, he will paint it. felmeans fault"(in Swedish), so I want to get the tester to register this error in the error tracking system whenever one of the test cases fails. In the column I have to indicate which identifier of this error in the error tracking system. So what I'm trying to achieve :

fel F, , I. , I- , F- fel, , - I, .

, :

=IF(AND(F5="Fel",I5=ISEMPTY(TRUE)),)

, . , , .

, , , , - I

+5
1

Cells F1:F10. , .

ISEMPTY. ISBLANK

=AND($F1="Fel",ISBLANK($I1))

, (F1:F10), $ , , -

enter image description here

+5

More articles:


All Articles