Italic
Naz wrote:
I have the following formula,
=if(A1=DueDate, sumif(Sheet2!A1:Sheet2!A100,A1,Sheet2!B1:Sheet2!B1 00),A1*4)
How can i get the cell to be italic if is picks up something from Sheet2,
and leave it non-italic if A1<DueDate.
Naz,
Check out conditional formatting
Beege
|