Mixed Reference Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/mixed-reference/ Bestselling Excel and Power BI Courses Tue, 05 Dec 2023 13:31:21 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Mixed Reference Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/mixed-reference/ 32 32 How to Use Excel Conditional Formatting with Formulas https://www.xelplus.com/excel-conditional-formatting-rows/ Thu, 03 Dec 2020 10:00:00 +0000 https://www.xelplus.com/?p=10404 Discover how to properly conditionally format rows in Excel with a Formula. This way you can highlight entire rows. I also share the secret to get it right every time.

The post How to Use Excel Conditional Formatting with Formulas appeared first on Xelplus - Leila Gharani.

]]> How to Properly Reference Cells in Excel – What is the Dollar Sign and When Do you Need it? https://www.xelplus.com/excel-cell-references/ Sat, 01 Feb 2020 14:35:00 +0000 https://www.xelplus.com/?p=11502 Properly referencing a cell is THE most important rule you need to master in Excel. Should the reference be relative, absolute or mixed? I explain it all in this quick article.

The post How to Properly Reference Cells in Excel – What is the Dollar Sign and When Do you Need it? appeared first on Xelplus - Leila Gharani.

]]>