I am trying to conditionally format my gantt chart and have used the formula: =AND(F$6>=$B9,G$6<=$C9). It does work, however it then highlights the entirety of the end column of my table. Is there a reason for this/how do I get rid?
Any help will be very much appreciated!!![Big grin :biggrin: :biggrin:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
Any help will be very much appreciated!!