Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2013, 07:52 AM
Triscia Triscia is offline Creating a Macro to change the shading of a cell Windows 7 32bit Creating a Macro to change the shading of a cell Office 2007
Novice
Creating a Macro to change the shading of a cell
 
Join Date: Jan 2013
Posts: 4
Triscia is on a distinguished road
Default Creating a Macro to change the shading of a cell

I have a table of membership members and when they attend a meeting I would like to be able to shade the cell with their name a particular color to show they have attended the meeting, by clicking on the cell and just hitting say ctrl/shift/c to change it to pink. TIA!
Reply With Quote
  #2  
Old 01-15-2013, 07:54 AM
OTPM OTPM is offline Creating a Macro to change the shading of a cell Windows 7 32bit Creating a Macro to change the shading of a cell Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi Triscia
This is better done using Excel as you can use Conditional Formatting.
Let me know if you want a sample.
Tony
Reply With Quote
  #3  
Old 01-15-2013, 08:08 AM
Triscia Triscia is offline Creating a Macro to change the shading of a cell Windows 7 32bit Creating a Macro to change the shading of a cell Office 2007
Novice
Creating a Macro to change the shading of a cell
 
Join Date: Jan 2013
Posts: 4
Triscia is on a distinguished road
Default

It would be, but they require us to use Microsoft Word. I would be able to do in Excel very easily, but Word, not so easy. If you have any ways it would be much appreciated. Thanks!
Reply With Quote
  #4  
Old 01-30-2013, 04:18 PM
macropod's Avatar
macropod macropod is offline Creating a Macro to change the shading of a cell Windows 7 64bit Creating a Macro to change the shading of a cell 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

When you have the relevant cell selected, shading it requires nothing more than clicking on the 'Shading' option on the 'Design' tab, then clicking the desired colour.

If you need something more automated, you could record a macro as you do this for one cell, then assign a keyboard shortcut to it.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
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
Creating a Macro to change the shading of a cell Creating formula based on if data is correct in cell MattMurdock Excel 1 08-06-2012 03:11 AM
change values based on cell ubns Excel 1 05-21-2012 06:28 PM
Detect a cell has un-approved change or not? LongTTH Excel Programming 1 05-20-2012 02:22 AM
Creating a Macro to change the shading of a cell how to change number in cell ubns Excel 5 05-14-2012 04:21 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:04 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