CoasterKing70
New Member
- Joined
- Nov 8, 2013
- Messages
- 3
I am looking for a simple code in VBA that compares a given date of a cell (cells(x,2)) to today's date. If the difference between the two dates is less than or equal to 3 days, I want to change the background color of cells(x,2) to red. I have used conditional formatting before but, I want to do this over an undetermined number of cells without maxing out the format limit.