Logo
DiS Needs You: Save our site »
  • Logo_home2
  • Records
  • In Depth
  • In Photos
  • Blog
  • Podcast
  • Search
  • Community
  • Records
  • In Depth
  • Blog
  • Community

THIS SITE HAS BEEN ARCHIVED AND CLOSED.

Please join the conversation over on our new forums »

If you really want to read this, try using The Internet Archive.

Boards

Music Social More…

FAO: Excel (2010) friends

Jordan_229_2 [Edit] [Delete] 15:21, 19 February '15

is there any way to determine if a cell has a validation rule dependent on the value of another cell?

what I want is:
C1 is "Core Business", apply a validation rule to C2 that only lets you pick from a list.
C1 is "Secondment", leave C2 as a free text cell with no validation rules.

I've already set up the lists for C1 and C2, I'm comfortable with that and with straight validation rules but not combined with IFs.

also did you have a haircut? it looks nice.


Drowned in Sound
  • DROWNED IN SOUND
  • HOME
  • SITE MAP
  • NEWS
  • IN DEPTH
  • IN PHOTOS
  • RECORDS
  • RECOMMENDED RECORDS
  • ALBUMS OF THE YEAR
  • FESTIVAL COVERAGE
  • COMMUNITY
  • MUSIC FORUM
  • SOCIAL BOARD
  • REPORT ERRORS
  • CONTACT US
  • JOIN OUR MAILING LIST
  • FOLLOW DiS
  • GOOGLE+
  • FACEBOOK
  • TWITTER
  • SHUFFLER
  • TUMBLR
  • YOUTUBE
  • RSS FEED
  • RSS EMAIL SUBSCRIBE
  • MISC
  • TERM OF USE
  • PRIVACY
  • ADVERTISING
  • OUR WIKIPEDIA
© 2000-2025 DROWNED IN SOUND