Conditional Formatting using Named Range

[pcm1969]

Hi,

I know the answer to this is probably easy, but it's been driving me crazy trying to figure it out! I have a range of data on Sheet1 (call it A1:A10) that needs to be conditionally formatted based on whether or not the value in each cell is less or greater than the value in a cell on Sheet2. The range in Sheet2 will be the same corresponding cells as Sheet1 and A1 on Sheet1 will be compared to A1 on Sheet2, A2 compared to A2 and so on. I don't need these to be dynamic, as the list won't grow. I know that I need to use a Named Range since I'm using Excel 2007 so I can't reference another Sheet, but I can't figure out how to do this without making each individual cell on Sheet 2 it's own named Range. I'd like to have one named range that knows as I copy the formula down to compare each row to it's corresponding row in the named range. I know a helper column would be the easiest solution to this, but the data on Sheet2 is restricted and the audience for this report can't see it and I've been hiding and locking the columns, but that isn't a great solution and it's causing it's own trouble. If I can get this named range method to work, then I think I can just hide and lock the Sheet 2 tab.

Hopefully this makes sense and there is any easy solution!

Thanks for your help!

[XOR LX]

Hi,

Please take a moment to read the Forum Rules re cross-posting.

Cross-posted here:

http://www.mrexcel.com/forum/excel-q...med-range.html

Regards

[FDibbins]

Hi and welcome to the forum

With the cross-link now posted, members can begin offering suggestions to you, but for future reference, please take a moment to read rule 8 regarding cross-posting

Thanks