I need help with a spreadsheet I have made for "ongoing project Timeline"

[lwebb]

So, I have made a what we call "job List" at work. This needs to be updated every month and shows, the next 12 months, with a proposed end date for each project we are doing. It needs to be visual like a bar graph and I wasn't sure on the best way to do this whilst making it time efficient to update. After a lot of trial and error I figured out a formula that works for what I needed.

I am using the IF formula, It adds the letter A to the cell if the date is before the anticipated end date (I then use conditional formatting to colour the cell in entirely) then the cells below work the same but with the letter B, the eventual shading then creates the "graph" in line with the dates. See images.

Formula example:
=IF(AND(T$4>='Date changes on this sheet'!$Y6,T$4<='Date changes on this sheet'!$Z6),"A","")

I know this is probably super over complicated for what I wanted to do so I am open to advise and ideas.

My problem with the method I am using, is that when I print this graph. It shows the letters A and letters B (even though the shading is the same colour on my computer to hide them) so its really not print friendly which this workbook has to be!

I would really appreciate any help you might be able to give with this!

*Please note I am no expert this is just me figuring it out as I go along*

Thank you very much!

 

[sparky2205]

Can you format those cells where the A and B are, either directly or through the conditional formatting?
If you use this it hides the cell contents: