akapol1955
02-04-2011, 03:24 PM
I found a macro here which converts any Tracked Changes to a Red font. A spreadsheet has been sent to our clients for updates, and some have used a red cell interior instead of red text to highlight their changes.
As is evident, running the macro causes those cells to have red text and a red interior, which causes a problem with legibility.
How would I search for all cells in a Workbook which have both red text and a red interior, and set the interior to XLColorIndexNone?
Thanks very much from a VBA novice - you all rock!
As is evident, running the macro causes those cells to have red text and a red interior, which causes a problem with legibility.
How would I search for all cells in a Workbook which have both red text and a red interior, and set the interior to XLColorIndexNone?
Thanks very much from a VBA novice - you all rock!