#LOGIC 2010 RIGHT CLICK NOT WORKING MAC UPDATE#
#LOGIC 2010 RIGHT CLICK NOT WORKING MAC FULL#

That adds the text, and the table expands, including the formulas вЂ“ but the conditional formatting doesnвЂ™t create a new rule.Д«e careful out there - donвЂ™t let this conditional formatting nightmare happen to you! Another Solution IвЂ™ve got a copy of that button on ExcelвЂ™s Quick Access Toolbar, so itвЂ™s easy to click. Now, when I want to save some typing time in the daily list, I copy the previous headings, and use the Paste Values button to create the new records. With all the extra rules gone, the conditional formatting borders were working correctly again. So, to clean up the mess, I cleared the conditional formatting from the worksheet, and set it up again. I scrolled through the list, and deleted a few of the rules, but quickly realized that it would take far too long to delete all of them. The previous solution is listed below, in case youвЂ™d rather try that. Get the detailed steps on my Conditional Formatting page.

#LOGIC 2010 RIGHT CLICK NOT WORKING MAC UPDATE#

UPDATE вЂ“ March 2017: IвЂ™ve found a quicker way to fix the problem, as you can see in this video. Now, it has two rules, instead of one, after one copy and paste within the table. LetвЂ™s take a look at the smaller example, where I just copied and pasted the Region and Product headings. That should give you some idea of how long that list was.Д®very time that I copied and pasted within the conditional formatting range, it created another rule for the worksheet.

You can see the tiny scroll box at the bottom right in the screen shot below. But, instead of one simple rule, there were hundreds of rules! So, I went into the Conditional Formatting Manager, to fix the problem.

#LOGIC 2010 RIGHT CLICK NOT WORKING MAC FULL#

Suddenly, this week, I started having trouble with the red border between dates вЂ“ it wasnвЂ™t going across the full table. Awesome!ДЄnd that copy and paste trick is what IвЂ™ve been doing every day, for months on end. The Excel table automatically expands to include the new rows, and fills in the formulas in column F. So, to save typing time, I copy and paste the headings from the day before.ДЇor example, in the screen shot above, I could copy the regions and products headings from B2:C4, and paste them into cell B10:C12, for the latest dayвЂ™s data. In the workbook, I track some daily statistics for my website, and use the same headings every day. The conditional formatting was set for cells A2:F9, and uses a simple formula to see if the date is equal to the date in the row above. The red border really makes the list easier to read, especially if IвЂ™m looking at it before my morning coffee!

ItвЂ™s a technique that I use in one of my own workbooks, which I update every morning. ItвЂ™s useful for alerting people to problems, hiding duplicate values in a column, or even hiding cellsвЂ™ contents, until related cells are filled correctly.Д®arlier this year, I posted a tip for separating dates in a list, by using a red border at the start of a date change. There are lots of ways to use Excel conditional formatting. Fortunately, the fix didnвЂ™t take too long, but with complex formatting, things could have been much worse. But this week I ran into a conditional formatting nightmare, and had to start from scratch. IвЂ™m a big fan of ExcelвЂ™s conditional formatting, and often use it to highlight cells on a worksheet.

Logic 2010 right click not working mac