Published On Apr 27, 2019
END YOUR DIGITING PROBLEMS ON YOUR WORKSHEETS AND HIGHLIGHTYOUR CELLS WITH CRITERIA
Also called Dropdown, list data validation is very useful for standardizing your spreadsheet data. There are situations where we find a single word typed in dozens of different ways, this is because the user is free to fill in a certain field as you wish.
With the drop down list, you will pre-define criteria to populate a cell.
See also in this video how to paint cells using conditions.
Optimize your management with this very simple yet extremely valid visual feature.
For example:
Highlight your goal achieved in green;
Alert the user when performance is poor with a red color;
Flag when tasks are completed or late;
Be creative and tell us if you solved your problem!
See you!
#Excel