(Excel) Conditional Formatting based on Adjacent Cell Value I'm trying to apply conditional formatting in Excel on a range of cells, based on the adjacent cell's value, to achieve something like this: The goal is to highlight values in Column B (Actual Expense) red if the value is greater than it's adjacent value in column C (Expected Expense)
What is the difference between . text, . value, and . value2? Using Value or Text is usually a bad idea because you may not get the real value from the cell, and they are slower than Value2 For a more extensive discussion see my Text vs Value vs Value2