Now we are ready to apply this function with conditional formatting. As a result, the MOD value of the ROW is always 0 for even numbered rows to 1 for odd-numbered rows. ROW numbers will always be an odd number, then an even number. MOD – provides the remainder of a division (for example MOD(5,2) provides a result of 1, because 5 goes into 2 twice, with a remainder of 1.) ROW – provides the row number of the cell To apply the colors to alternating rows we will be using conditional formatting combined with the ROW and MOD functions: Find out the exact RGB (Red, Green, Blue) color values and make note of them, you will want to apply these when applying the conditional formatting. How to apply alternating colors rows using conditional formattingįirstly, find out the exact colors you wish to apply. If you are ever in this situation, do not do it this way – you will only be wasting your life by having to do it over and over again. So I only had one option, I had to go back and do it all over again. Then once I was done, I noticed the colors were not exactly the same shade as PowerPoint, they were similar, but not the same. Arrrrggghhh!!!! The formatting would then not be alternating, so I would have to go back through and start alternating the colors again. Then a new line would need to be added into the middle, or the rows had to be re-ordered. I had spent hours formatting every line to be alternating colors. I had been in a similar situation previously. How NOT to apply alternating colors to rows Then came the words I had been dreading to hear: “Can you make all the tables in the presentation in the same format with the alternating stripes?”. In the presentation, there are also some PowerPoint tables in the default blue striped layout. This technique is great because the presentation automatically updates each time the Excel worksheets change. Much of the presentation is constructed from linked Excel worksheets into PowerPoint. A couple of weeks ago we were preparing for a presentation.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |