Font sensitve lookup - is it possible?

[stevo]

Columns A:B contains videos and their retail price. I want to highlight in italics the rows of the items which are out of stock.

I want to keep the price of the out of stock items in there for reference but highlight them in italics. This is so I can predict the total sales without having to delete these rows.

How do I create a formula that will sum the prices in column B of all the items except the ones in italics? Is this possible?

[mangesh_yadav]

An easier way would be:

Add a column, where you would enter 1 for rows that are out of stock. You may hide this column. Lets say this column is C.
Then select the 2 columns A and B. Go to Format > Conditional Formatting, select Formula Is and enter in the box
=C1=1
and click format, format text as italics
Then to sum the rows, simply use the SUMIF function
=SUMIF(C1:C10,"<>1",B1:B10)

Mangesh

[Don Guillett]

try this
Sub sumNONitalics()
For Each c In Range("c2:c6")
If c.Font.FontStyle <> "Italic" Then mt = mt + c
Next
MsgBox mt
End Sub


--
Don Guillett
SalesAid Software
[email protected]
"stevo" <[email protected]> wrote in
message news:[email protected]...
>
> Columns A:B contains videos and their retail price. I want to highlight
> in italics the rows of the items which are out of stock.
>
> I want to keep the price of the out of stock items in there for
> reference but highlight them in italics. This is so I can predict the
> total sales without having to delete these rows.
>
> How do I create a formula that will sum the prices in column B of all
> the items except the ones in italics? Is this possible?
>
>
> --
> stevo
> ------------------------------------------------------------------------
> stevo's Profile:
http://www.excelforum.com/member.php...o&userid=10737
> View this thread: http://www.excelforum.com/showthread...hreadid=378508
>