Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

compare then Strikethrough

Posted by Andonny on June 02, 2001 9:39 PM

Hi,
I am trying to compare Column A,B and C.
If it finds a duplicate row then it should put a Strikethrough into the cell in column C. The only other thing is that the cells in C column are not hundred percent the same. They have a positive number and a negative number of the same. Like "-5" and "+5". The reason why I would like to Strikethrough is because they cancel each other out.

Thanks a million
Andonny

Re: compare then Strikethrough

Posted by Kevin James on June 02, 2001 9:44 PM

Andonny

Use the ABS function in your conditional format statement.

Kevin

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.