 | |
| Excel Conditional Formatting the Lookup result in data table (Index Match) |
Find out how you can highlight values inside your data set based on a condition. In this example, we are going to conditionally format the result of our lookup formula (I use INDEX Match here) to conditionally format that same value that we find inside the original data set.
The tricky part is to get the conditional formatting formula correct. Just remember, one reason why your conditional formatting formulas might not work can be due to the wrong usage of the dollar sign for fixing the cell references (i.e. absolute, versus relative referencing - and sometimes you need a mix of the two).
Related Topics:
Post a Comment