Excel 2007 - Named range (not continuous)

Hewlett-packard / X
December 13, 2010 at 05:15:02
Specs: Win 2003, 512
Hi,

I am having difficulty with using a Named range that is not continuous in Conditional Formatting, is it possible to use a non continuous named range? If the Named Range is continuous it works fine but for my project I'd like it to be non-continuous. I can't find any information on this on the web anywhere.

Any information will be helpful.

Much appreciated,
Kasey


See More: Excel 2007 - Named range (not continuous)

Report •


#1
December 13, 2010 at 05:55:46
Please be a little more specific regarding what you are trying to do.

I don't have any trouble using CF on a non-contiguous named range (e.g A1:A7, C1:C7) in 2003.

I can't test 2007 (actually 2010) until I get home, but maybe if you tell us what you are trying to do in more detail, we can help.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

#2
December 13, 2010 at 06:40:03
I have a calendar, so 12 months.
Jan in cells A6 : G11
Feb in cells I6:011
Mar in cells Q6:W11

.... etc for the other months

underneath each month there are 5 rows to enter Holiday dates, for example Jan, A12:B12 merged up to row 16. I named "My_holiday" range =Calendar!$A$12:$B$16,Calendar!$I$12:$J$16,Calendar!$Q$12:$R$16,Calendar!$A$26:$B$30,Calendar!$I$26:$J$30,Calendar!$Q$26:$R$30,Calendar!$A$40:$B$44,Calendar!$I$40:$J$44,Calendar!$Q$40:$R$44,Calendar!$A$54:$B$58,Calendar!$I$54:$J$58,Calendar!$Q$54:$R$58

I want to use CF to highlight a date if there is a date entered in the named range "My_Holiday". The CF formula =COUNTIF(My_Holiday,$A6)=1

Hope this is clear.

Thx
K


Report •

#3
December 13, 2010 at 19:54:45
You've lost me.

I can't tell what cells are setup for CF, or what you mean by A12:B12 merged up to row 16 or where users are entering their dates.

Please explain this.

Posting Tip: Before posting Data or VBA Code, read this How-To.


Report •

Related Solutions


Ask Question