Top "Excel-r1c1-notation" questions

Questions about Excel formulas that use the R1C1 notation for describing absolute and relative ranges.

Conditional formatting using the INDIRECT function fails with boolean AND or OR or with cells containing formulas

I have the following function for checking whether column L contains the word "completed" and I use INDIRECT to be …

excel excel-formula excel-2013 excel-r1c1-notation