Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 15th 15, 09:27 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2013
Posts: 8
Default Conditional formatting on dynamic named range

Hello
I have an Excel 2007 sheet with a dynamic named range, "WholeMain", to which I apply some conditional formatting. When I apply a formatting to range ="WholeMain" it changes the range to absolute address =$A$1:$V$379;$A$399:$V$768 skipping the rows 380...398. I have tried to delete the range name and recreate it. I have also recreated all conditional formatting without any success. For any reason one of the formatting clause applies to those rows, but leaving column C unformatted.

Regards
Håkan

  #2   Report Post  
Old April 15th 15, 10:04 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,866
Default Conditional formatting on dynamic named range

Hi Hakan,

Am Wed, 15 Apr 2015 01:27:00 -0700 (PDT) schrieb Håkan Björkström:

I have an Excel 2007 sheet with a dynamic named range, "WholeMain", to which I apply some conditional formatting. When I apply a formatting to range ="WholeMain" it changes the range to absolute address =$A$1:$V$379;$A$399:$V$768 skipping the rows 380...398. I have tried to delete the range name and recreate it. I have also recreated all conditional formatting without any success. For any reason one of the formatting clause applies to those rows, but leaving column C unformatted.


that is a fix range.
A dynamic range should be
=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A),COUNTA( Sheet1!$1:$1))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
  #3   Report Post  
Old April 15th 15, 10:15 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2013
Posts: 8
Default Conditional formatting on dynamic named range

Den onsdag 15 april 2015 kl. 12:05:03 UTC+3 skrev Claus Busch:
Hi Hakan,

Am Wed, 15 Apr 2015 01:27:00 -0700 (PDT) schrieb Håkan Björkström:

I have an Excel 2007 sheet with a dynamic named range, "WholeMain", to which I apply some conditional formatting. When I apply a formatting to range ="WholeMain" it changes the range to absolute address =$A$1:$V$379;$A$399:$V$768 skipping the rows 380...398. I have tried to delete the range name and recreate it. I have also recreated all conditional formatting without any success. For any reason one of the formatting clause applies to those rows, but leaving column C unformatted.


that is a fix range.
A dynamic range should be
=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A),COUNTA( Sheet1!$1:$1))


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional


Yes, this is the formula.
Håkan


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting 'Named Range' dilemma Blue Max Excel Worksheet Functions 4 December 22nd 08 09:16 PM
Conditional Formatting - 2 Worksheets one Named Range Sam via OfficeKB.com Excel Worksheet Functions 5 January 27th 07 03:00 PM
named range in conditional formatting Joanne Excel Programming 3 October 17th 06 01:18 PM
Conditional Formatting & Dynamic Range james Excel Worksheet Functions 2 October 11th 05 04:25 PM
named range, conditional formatting drabbacs[_2_] Excel Programming 3 May 17th 05 06:12 PM


All times are GMT +1. The time now is 10:01 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017