If Conditional formatting is not applying to all cells in Excel or Google Sheets, you need to check the formatting and rules.
Use Excel's conditional formatting to flag status changes, budget issues, missing data, duplicates, and deadlines ...
Q. What is the difference between a regular paste in Microsoft Excel and Paste Special? A. As an accountant, you know how to copy or cut and paste in Microsoft Excel. On PCs, it’s as simple as Ctrl+C ...
If you copy a formula and paste it into the next cell down, Excel shifts that referenced cell, so it will say A2 instead. To prevent shifting, use the dollar sign ($).