Add value to conditionnal formatting

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

I'm not sure I understand your condition formula, but if the cell is empty
to begin with, and all you want to do is have a "1" put in the cell when it
turns blue, I suppose you could use a similar IF formula in the cell itself.



"Paul" <[email protected]> wrote in message
news:[email protected]...
> 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
>