Conditionally Formatting cells based on other conditionally formatted cells

[MikeyC2002]

Hey team, I'm currently working to create a "Project Timeline" using conditional formatting. The values I'm using are in Fiscal Quarters (Q1, Q2, Q3, etc). If we have a project starting in Q1 and ending in Q3, I can easily highlight Q1 and Q3 using simple conditional formating, but that leaves the Q2 cell blank and I wish to have that conditional formatted as well so it's a solid line. Does anyone have any ideas how to accomplish this? Any help would be much appreciated!

 

[Joe4]

Welcome to the Board!

You didn't say what your current conditional formatting rules are, but note that you can use formulas in conditional formatting, so you can format cells based on the values in OTHER cells.
If you need help figuring out the formula on how to do that, please provide specific details on how your data is laid out, and how you want it to work.