Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-19-2013, 02:45 AM
ChiCotje ChiCotje is offline Automatical backgroundcolor change based on cell value Windows 7 32bit Automatical backgroundcolor change based on cell value Office 2010 32bit
Novice
Automatical backgroundcolor change based on cell value
 
Join Date: Feb 2013
Posts: 2
ChiCotje is on a distinguished road
Question Automatical backgroundcolor change based on cell value

Hello, I have a table in words with dropdown menu's in certain cells. the selection creteria in the dropdownmenu are words (open, closed etc.) Now I want that the cell's backgroundcolor automatically change based on the selected criteria from the dropdown menu.

I can manage to do this in Excel. You don't need any special kind of macro for that. But now I want to apply this in a table created in Words 2010.

Can anyone help me with this?
Reply With Quote
  #2  
Old 02-19-2013, 05:50 PM
macropod's Avatar
macropod macropod is offline Automatical backgroundcolor change based on cell value Windows 7 64bit Automatical backgroundcolor change based on cell value Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi ChiCotje,

See attached. These documents were originally created for other threads/forums. One document uses content controls (for Word 2007 & later), the other uses formfields (for all Word versions). Both solutions require a macro.
Attached Files
File Type: zip Dropdown Conditional Format.zip (43.2 KB, 12 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-20-2013, 01:13 AM
ChiCotje ChiCotje is offline Automatical backgroundcolor change based on cell value Windows 7 32bit Automatical backgroundcolor change based on cell value Office 2010 32bit
Novice
Automatical backgroundcolor change based on cell value
 
Join Date: Feb 2013
Posts: 2
ChiCotje is on a distinguished road
Default

Thanx! I am gonna try it out :-)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM
change values based on cell ubns Excel 1 05-21-2012 06:28 PM
Macro based on cell value ubns Excel Programming 1 05-07-2012 04:03 AM
Calculating a cell value based on many variables malawimick Excel 0 12-14-2011 05:29 PM
Automatical backgroundcolor change based on cell value How to highlight the row based on cell value? Learner7 Excel 1 12-11-2011 02:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:13 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft