by Ilker | May 17, 2018 | Excel Tips & Tricks
To highlight a row may be tricky because there is no built-in option to in Excel’s Conditional Formatting feature. Here, you can find out how you can do this dynamically using Excel formulas. Steps Begin by selecting rows by clicking on row numbers Open...
by Ilker | Apr 27, 2018 | Excel Tips & Tricks
It’s often a good idea to highlight duplicate values in a data set to help easily identify the outliers. Here, you can find out how you can do this dynamically using Excel formulas. Syntax =COUNTIF(absolute data range reference, relative cell reference) Steps Begin by...
by Ilker | Apr 23, 2018 | Excel Tips & Tricks
It’s often a good idea to highlight the top values in a data set to help easily identify the outliers. Here, you can find out how you can do this dynamically using Excel formulas. Syntax =relative cell reference >= LARGE(absolute data range reference, top...
