I'm trying to add a couple of FormatConditions to a range based on Formulas (xlExpression?).
The range spans a couple of table columns so I need to build the formula based on a relative cell address so the formatting is referencing the cell's own value.
I have this working fine via Excel's Conditional Formatting, but I'm struggling with the VBA code.
Building the range was fine:
The conditional formatting in Excel, looks like this:Please Login or Register to view this content.
How do I convert my first table cell reference so it reads "AQ6", and how do I build the formatting condition in VBA?Please Login or Register to view this content.
Please Login or Register to view this content.
Any help would be greatly appreciated.
Thanks.
Bookmarks