Italic

N

Naz

I have the following formula,

=if(A1=DueDate, sumif(Sheet2!A1:Sheet2!A100,A1,Sheet2!B1:Sheet2!B100),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.
 
B

Beege

Naz said:
I have the following formula,

=if(A1=DueDate, sumif(Sheet2!A1:Sheet2!A100,A1,Sheet2!B1:Sheet2!B100),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.
Click to expand...

Naz,

Check out conditional formatting

Beege
 
Top