I want to use Conditional Formatting to format the cells above with an " x " in them to instead shade/fill the same color (say, light blue) throughout the range C4 through L7. I tried using an AND statement using the 'Use a formula . . . ' formatting rule, such as =AND($A4>$D2, and I don't know how to complete the formula. How do I do this? (NOTE: There are hundreds of rows and columns in the file I'm working in; this is just an example. For those familiar with Gantt chart scheduling, I basically want to show the months where there is activity occurring in a month with shading.) Thanks for the assistance!