Font sensitve lookup - is it possible?
 

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

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


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=378508

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

"stevo" wrote in
message ...

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