| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup and change to italic italic | Excel Worksheet Functions | |||
| How to count the number of Excel cells with text formatted Italic | Excel Worksheet Functions | |||
| change format of cells (bold, italic) based on one cell's answer | Excel Discussion (Misc queries) | |||
| How to apply both Italic & Bold in Header & Footer? | Excel Discussion (Misc queries) | |||
Linear Mode
