Conditional formatting

barrywood Posts 1 Registration date Sunday October 4, 2015 Status Member Last seen October 4, 2015 - Oct 4, 2015 at 02:31 AM
I am trying to format a column B2 to B56 with different dates in each row to change yellow when each date is 30 days before the due date and red when on the due date. Any row without data to stay white. I am using excel 2010.