JYool
New member
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
are these things not available on tables?
thanks
J