Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #14  
Old 11-29-2014, 10:28 AM
BobBridges's Avatar
BobBridges BobBridges is offline highlight the entire row of current cell Windows 7 64bit highlight the entire row of current cell Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Aww, Peco beat me to it. If you want to do it with VBA it's easy, but he's right, you should be able to do it with conditional formatting too.

If you still want to write a macro to do it, or if you already have a VBA program and you want to teach it to do something to the entire row, you just need the EntireRow property of the date cell.
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
highlight the entire row of current cell Excel 2007, highlight entire row based on data found in one cell MSofficeBLUE Excel 2 10-15-2013 09:51 PM
Is there a way to automatically highlight the column and the row that of the current Jamal NUMAN Excel 8 02-14-2012 02:58 PM
highlight the entire row of current cell How to highlight the row based on cell value? Learner7 Excel 1 12-11-2011 02:28 AM
highlight the entire row of current cell Macro for moving one cell down from current position Johnny thunder Word VBA 3 04-07-2011 04:44 PM
highlight cell after checkbox flatk Word 0 01-25-2007 12:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:04 AM.


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