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 have
