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!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Formatting for a Gantt Chart Type Schedule
- Thread starter MntnrMark
- Start date
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!
Excel Facts
Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
DRSteele
Well-known Member
- Joined
- Mar 31, 2015
- Messages
- 2,654
- Office Version
- 365
- Platform
- Windows
I understand from what you tried to say that you want the cells C4:L7 to have a blue fill when the dates in Start and Finish coincide with the dates in C2:L2. For example, there was an X in cell F4 because there was activity in October/21.
If that is so, highlight C4 to L7 and paste this into the New Rule box and pick a format (like blue fill).
=AND(C$2>=(EOMONTH($A4,-1)+1),C$2<=(EOMONTH($B4,0)))
If that is so, highlight C4 to L7 and paste this into the New Rule box and pick a format (like blue fill).
=AND(C$2>=(EOMONTH($A4,-1)+1),C$2<=(EOMONTH($B4,0)))
Upvote
0
Solution
Hmmm. That's not doing it. I'm not getting anything in C4 through L7 at all. I triple checked the formula. Any thoughts on why that isn't working?
Upvote
0
Microsoft Excel for Microsoft 365 MSO 64-bit.
Upvote
0
OK, now its working. For the life of me I don't know why it wasn't working earlier, but it is now. THANK YOU SO MUCH!
Upvote
0
Similar threads
- Solved
