RE: $$Excel-Macros$$ VBA script to change cell color if text has strikethrough

2012-06-06 Thread Rajan_Verma
d Grugeon Sent: 06 June 2012 12:08 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ VBA script to change cell color if text has strikethrough There are problems with this as the conditional formatting overrides any locally applied formatting so the macro would need to exclude that

Re: $$Excel-Macros$$ VBA script to change cell color if text has strikethrough

2012-06-05 Thread David Grugeon
There are problems with this as the conditional formatting overrides any locally applied formatting so the macro would need to exclude that cell from the conditional formatting - not easy and not advisable. Conditional formats can get confused enough without any help. I would suggest you have a c

Re: $$Excel-Macros$$ VBA script to change cell color if text has strikethrough

2012-06-05 Thread NOORAIN ANSARI
Dear Michael, Please share a sample workbook with Group. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, Jun 6, 2012 at 2:03 AM, Michael Landry wrote: > I am working on a spreadsheet that contains several columns with due > dates. I have cond