Project management: fillblock

[dschnetzer]

I am creating a project management report using fillblock function and would like to vary the color of the blocks depending on the event/task (e.g., period lost to holidays appears red, standard task appears blue). Is there a way to do this? Following is the formula:


=IF(AND(COLUMNS($H$9:O12)>=$C12,COLUMNS($H$9:O12)<=$D12),IF(COLUMNS($H$9:O12)-$C12<ROUND(($D12-$C12+1)*$F12,0),fillblock,""),"")

 

[Hui]

Dschnetzer


Firstly, Welcome to the Chandoo.org Forums


Fillblock is not a native Excel function or is a Named Formula, so I assume you are using an Addin or not using Excel


You can use Conditional Formatting in Excel to fill cells based on criteria

Refer:

http://chandoo.org/wp/2009/03/13/excel-conditional-formatting-basics/

&

http://chandoo.org/wp/2008/03/13/want-to-be-an-excel-conditional-formatting-rock-star-read-this/