Excel Depended Lists Data Validation

Excel Depended Lists Data Validation
Now that we experimented with simple Data Validation, let’s go back to try out more dynamic Data Validation. Our ultimate goal is to create a State/City dependent columns. In other words, we want to create dependency between two cells. When value is entered in the State cell, the List Data Validation will be dynamically changed ...

Excel Conditional Formatting for Whole Rows

Excel Conditional Formatting for Whole Rows
In the basic Excel “Conditional Formatting” the formatting of a single cell is done based on its value. That way, for example, one can highlight a cell if it contains the value “Highlight”. To do that simply select the needed cell and click on the “Conditional Formatting” option “Highlight Cells Rules” and select the type ...