Italic

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Please explain this formula 2
Search Entire Sheet instead of 1? 4
Cell Content via Secondary Formula 2
Cell highlighting question 4
Selecting a cell entry based on cell validation selection 2
Sum If function 3
Lookup 4
Array formulas help needed 3

Back
Top