Results 1 to 4 of 4

Thread: conditional formatting in excel tables

  1. #1
    Seeker JYool's Avatar
    Join Date
    Aug 2011
    Location
    Courtenay, BC, Canada
    Posts
    17
    Articles
    0

    conditional formatting in excel tables



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    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.

  3. #3
    Seeker JYool's Avatar
    Join Date
    Aug 2011
    Location
    Courtenay, BC, Canada
    Posts
    17
    Articles
    0
    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?

  4. #4
    Well I use A1 notation, but basically yes.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •