ExcelBanter - Italic

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Italic (https://www.excelbanter.com/excel-worksheet-functions/142295-italic.html)

Naz

Italic

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,
London

Beege

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

All times are GMT +1. The time now is 05:10 AM.