conditional formatting in excel tables

[JYool]

I've been noticing that there are some distinct advantages to storing data in tables in excel 2007 instead of named ranges, or totalling your own columns... however, i have not been able to get conditional formatting or data validation to take in these tables. I know the tables want to stay pretty, but i would really like to be able to indicate to users where they should be able to fill out or not fill out, or indicate if a field doesn't exist in another list by hilighting the name.

are these things not available on tables?

thanks

J

[Bob Phillips]

I did find that you cannot use structured references in a table CF, you need the old style row/column references. I did blog about t, it is rubbish.

[JYool]

I'll stick with named ranges for my non-dynamic data for now then. Save the tables for when i need table functionality. What you are saying though, is that i can use r1c1 in CF?

[Bob Phillips]

Well I use A1 notation, but basically yes.