Hi,

Newbie question:

I'm creating a Gantt Chart and would like to add the number 1 to each cell
that meets the condition. The conditional formatting formula is:

=AND(L$56>=$D82;L$56<=$E82) ...it makes the cell blue. How can have the
number "1" also added in the cell?

Thanks.

Paul