Thread: Italic
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Beege Beege is offline
external usenet poster
 
Posts: 66
Default 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