If it possible to use conditional formatting so that if you choose a specific item from a drop down list, you automatically move to a particula column in that same row? I have a spreadsheet that I'm using for bank balancing and I was to move directly to the debit column if I choose "transfer out" from the drop down list in the transaction column.
Welcome to the forum.
No, conditional formatting cannot do that - formatting is to do with the way a cell looks (colours/borders/text). If it's possible at all, it will require VBA coding. Shall I move the thread for you?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Yes, could you please move this thread for me? Thanks so much for your help!
Yes, could you please move this to the correct forum? Thanks so much for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks