conditional formatting in excel tables

JYool

New member
Joined
Aug 24, 2011
Messages
17
Reaction score
0
Points
0
Location
Courtenay, BC, Canada
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

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
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

New member
Joined
Aug 24, 2011
Messages
17
Reaction score
0
Points
0
Location
Courtenay, BC, Canada
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

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Well I use A1 notation, but basically yes.
 
Top