hi
can you not refer your named range in conditional formatting.
On Thu, Dec 8, 2011 at 4:22 AM, Rohan wrote:
> Not figured out what your macro ishowever what I can suggest you
> can use the Offset function to have the range of the
> Conditional formating extended automatically.
>
> Use, =Of
Not figured out what your macro ishowever what I can suggest you
can use the Offset function to have the range of the
Conditional formating extended automatically.
Use, =Offset(A1, Counta(A:A), 0), assuming you want to apply
conditional formatting in the column A.
Put the above stated formula
Post your macro code and/or attach your file.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: zp18
Sent: Tuesday, November 22, 2011 5:52 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Conditional Formatting using named ranges
Excel 2007-
I
Excel 2007-
I have a large spreadsheet that I add 2 rows to daily. I also have
about a dozen conditional formatting formulas that flag certain
conditions for quick identification. The worksheet that gets the
daily data is named "DataSheet"
I've written a quick VBA Macro that sets a named range