Thread: Conditional Formatting - color only dates contained in a range
View Single Post
 
Old 07-08-2014, 12:51 PM
whatsup whatsup is offline Windows 7 64bit Office 2010 32bit
Competent Performer
  
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default
Hi

Use the formula section of cond. formatting:
=AND(D2>S2,D2<U2)
Reply With Quote