Hi,
Need to show the progress of activity as Line in Gantt Chart with the help of conditional formatting.
An excel file attached with necessary detils.
Pl. help.
Thanks,
Nagesh.
Hi,
Need to show the progress of activity as Line in Gantt Chart with the help of conditional formatting.
An excel file attached with necessary detils.
Pl. help.
Thanks,
Nagesh.
What you are showing is not formatting, so it can't be done with conditional formatting. The closest I could come is a formula. Put this formula in J12 then copy and Paste Formula to the other cells. The graphics characters do not fill the whole cell at the width you are using so it's not going to look exactly like your example.
Formula:Please Login or Register to view this content.
With cell I8 as the current week, cell J12 =IF($F12=J$10,"├",IF($G12=J$10,"┤",IF(AND(AND($F12<=J$10,$F12>0),OR($G12>=J$10,$G12=0),$I$8>=J$10),"─","")))
Format range J12:AS16 with SimSun fonts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks