Posts1Registration dateFriday November 29, 2013StatusMemberLast seenNovember 29, 2013
Nov 29, 2013 at 04:47 PM
Posts2921Registration dateSunday September 12, 2010StatusModeratorLast seenJanuary 16, 2023
Dec 5, 2013 at 10:24 AM
I need to create conditional formatting in Excel separately for a number of rows (e.g. high lighting highest and lowest values in each row). I have created the rules for one row and now need to apply that to all other rows. I cannot do one 'paste special' per row since I have many rows. Is there any way to do that?!
Posts2921Registration dateSunday September 12, 2010StatusModeratorLast seenJanuary 16, 2023549 Dec 5, 2013 at 10:24 AM
I always drag my formatted cells down, messing up your data, but when done a small square appears. Clicking this square gives you the option to apply format only, thus restoring your data but keeping the conditional format.