View Single Post
  #3   Report Post  
jerry_maguire jerry_maguire is offline
Junior Member
 
Posts: 25
Default Highlight overlapping date ranges using conditional formatting

Select the cell range for example B6: D12.
Click the "Home" tab.
Click the "Conditional Formatting" button.
Click "New Rule..".
Click "Use a formula to determine which cells to format".
Type =SUMPRODUCT(($C6<=$D$6:$D$12)*($D6=$C$6:$C$12))1 in "Format values where this formula is TRUE" window.
Click the "Format.." button.
Click the "Fill" tab.
Pick a color. This color is used to highlight records that overlap.
Click "OK".

You can check more about Excel tips on https://www.o365cloudexperts.com

Regards,
Jerry