Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-17-2017, 12:40 AM
puff puff is offline Automatically color the right options in red based on the answers provided Windows 7 64bit Automatically color the right options in red based on the answers provided Office 2013
Advanced Beginner
Automatically color the right options in red based on the answers provided
 
Join Date: Apr 2017
Posts: 60
puff is on a distinguished road
Question Automatically color the right options in red based on the answers provided

I'm preparing an answer key for my students and my document looks like this:
Q1:XXXXXXXX?
1. XXX
2. XXX
3. XXX
4. XXX
2 (option 2. is the correct answer to the 1st question)
(a blank line)
Q2:XXX?


...(repeat)

Is that possible to write a macro to color the respective correct options into red based on the key provided on every 7th line and then delete all those lines? Does anyone have a hint?

Last edited by puff; 12-17-2017 at 02:57 PM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Color (Being provided between the two codes) bnyamin Word VBA 4 05-16-2017 10:55 PM
Macro- find and replace from preselected options based on frequency (like an Ad libs) blondie Word VBA 0 02-27-2017 01:41 PM
Automatically color the right options in red based on the answers provided Cell Color based on date jrfoley3 Excel 3 08-26-2016 10:49 PM
Automatically color the right options in red based on the answers provided Need to create a "Yes/NO" Form and based on answers prompt for informatin jaradani Word 4 10-12-2014 09:42 PM
Changing bar color automatically Mahmuz PowerPoint 0 03-28-2012 11:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:22 PM.


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