Hi guys,
I've got a basic spreadsheet (attached) with data validation and depending on what is input into a certain cell, I wanted a few different things to happen:
1. If Column C has value Completed then Column F should have a value.. If F is blank then it should be display in Colour or the cell highlighted
2. If Column C has value Completed, then Column F should have Value, then Column K should have value... else display column F in colour or highlighted
3. IF Column B is Execute Test Case then column N should contain value else display in color for column N.
Thanks in advance
N
I've got a basic spreadsheet (attached) with data validation and depending on what is input into a certain cell, I wanted a few different things to happen:
1. If Column C has value Completed then Column F should have a value.. If F is blank then it should be display in Colour or the cell highlighted
2. If Column C has value Completed, then Column F should have Value, then Column K should have value... else display column F in colour or highlighted
3. IF Column B is Execute Test Case then column N should contain value else display in color for column N.
Thanks in advance
N