Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #16  
Old 11-30-2014, 06:54 AM
cwksr cwksr is offline highlight the entire row of current cell Windows 8 highlight the entire row of current cell Office 2013
Novice
 
Join Date: May 2011
Location: Bucks County PA
Posts: 15
cwksr is on a distinguished road
Default


Perfect...thanks both for the answers!
  #17  
Old 12-01-2014, 03:06 AM
cwksr cwksr is offline highlight the entire row of current cell Windows 8 highlight the entire row of current cell Office 2013
Novice
 
Join Date: May 2011
Location: Bucks County PA
Posts: 15
cwksr is on a distinguished road
Default

Won't work using the conditional formatting.....and I'm not versed at all in VBA to construct it.

All of my dates are from 1/1/14 in "a4" down to "a369" ending with 12/31/14....I've selected the row (I started with row 3), in CF put =$a3=today() and nothing occurred.

Last edited by cwksr; 12-01-2014 at 06:00 AM.
  #18  
Old 12-01-2014, 07:23 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

I just did a little testing here, and I see that your formula should work if A3 has a date in it. So I'm guessing what it has is a character string. If so, then you can either translate column A to dates, or change your formula to convert TODAY() to a character string in the format matching column A, like this:
Code:
=$A3=TEXT(TODAY(),"m/d/yy")
That works on my machine.
  #19  
Old 12-02-2014, 04:16 AM
cwksr cwksr is offline highlight the entire row of current cell Windows 8 highlight the entire row of current cell Office 2013
Novice
 
Join Date: May 2011
Location: Bucks County PA
Posts: 15
cwksr is on a distinguished road
Default

yeah not sure whats going on here, but I can only have conditional formatting highlight the cells in column A to reflect the current date...won't show an entire row....Still plugging along trying different things.
  #20  
Old 12-02-2014, 06:41 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

Oh, I'm sure this can be worked out. If you care to, let's get down into the details: Post a copy of the worksheet, with your attempt at the conditional rule, and I'll see whether I can figure out what's going wrong.
  #21  
Old 12-02-2014, 09:02 AM
cwksr cwksr is offline highlight the entire row of current cell Windows 8 highlight the entire row of current cell Office 2013
Novice
 
Join Date: May 2011
Location: Bucks County PA
Posts: 15
cwksr is on a distinguished road
Default try this

here...i'm trying to highlight using whatever can be used, the entire row of "today".

thanks..
Attached Files
File Type: xlsx Book1.xlsx (112.9 KB, 12 views)
  #22  
Old 12-02-2014, 10:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline highlight the entire row of current cell Windows 7 64bit highlight the entire row of current cell Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by cwksr View Post
Won't work using the conditional formatting.....and I'm not versed at all in VBA to construct it.

All of my dates are from 1/1/14 in "a4" down to "a369" ending with 12/31/14....I've selected the row (I started with row 3), in CF put =$a3=today() and nothing occurred.
Well if you start your dates in A4, the condition shoud be =$A4=today() not $A3
Attached Files
File Type: xlsx Book1.xlsx (125.1 KB, 9 views)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
  #23  
Old 12-02-2014, 11:02 AM
cwksr cwksr is offline highlight the entire row of current cell Windows 8 highlight the entire row of current cell Office 2013
Novice
 
Join Date: May 2011
Location: Bucks County PA
Posts: 15
cwksr is on a distinguished road
Default it was typographical error

I did use the a4.....but posted before I re-read
  #24  
Old 12-02-2014, 12:18 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline highlight the entire row of current cell Windows 7 64bit highlight the entire row of current cell Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

To apply the CF you must first choose the entire range $A$4:$Y$368 THEN apply the CF to that range.

HTH
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
  #25  
Old 12-02-2014, 02:44 PM
cwksr cwksr is offline highlight the entire row of current cell Windows 8 highlight the entire row of current cell Office 2013
Novice
 
Join Date: May 2011
Location: Bucks County PA
Posts: 15
cwksr is on a distinguished road
Default

Thanks for all the input. Not sure if my version of Office 2013 doesn't want to co-operate with everyone's suggestions or what..but nothing is working.
  #26  
Old 12-02-2014, 08:12 PM
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

Well, I was able to do it in Excel 2010, even over all those other conditional formats. What is it you tried? This worksheet doesn't seem to include your attempt at the date highlighting.
  #27  
Old 12-03-2014, 01:02 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline highlight the entire row of current cell Windows 7 64bit highlight the entire row of current cell Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Quote:
Originally Posted by cwksr View Post
Thanks for all the input. Not sure if my version of Office 2013 doesn't want to co-operate with everyone's suggestions or what..but nothing is working.
Did it not work in the sheet I posted?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
  #28  
Old 12-03-2014, 08:48 AM
cwksr cwksr is offline highlight the entire row of current cell Windows 8 highlight the entire row of current cell Office 2013
Novice
 
Join Date: May 2011
Location: Bucks County PA
Posts: 15
cwksr is on a distinguished road
Default sorry for the delay

My day off today and had some chores to get done 1st thing.

I had made a copy of the sheet I posted which probably didn't have anything I tried.
  #29  
Old 12-03-2014, 08:51 AM
cwksr cwksr is offline highlight the entire row of current cell Windows 8 highlight the entire row of current cell Office 2013
Novice
 
Join Date: May 2011
Location: Bucks County PA
Posts: 15
cwksr is on a distinguished road
Default Yes, in fact it did work

Quote:
Originally Posted by Pecoflyer View Post
Did it not work in the sheet I posted?

I did the same exact formula/function in CF.

I'm going to try it on the main copy....letter for letter.... We shall see.

This happened when I tried to do it on the main workbook...
entering the formula itself would not work.
I had to enter the formula..make the changes I wanted it to show thru CF
Save it
Go back into it, edit the range(in cf after the "format" box...ie.. =$A$4:$Y$368
save it
had noticed it changed the initial formula in the CF box to "=$A1053782"
changed that back to =$A4=TODAY()

and it worked.
maybe something in the options in Excel?? Was a tough go.......but thank you all.
  #30  
Old 12-03-2014, 10:32 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline highlight the entire row of current cell Windows 7 64bit highlight the entire row of current cell Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Perhaps that's what we pilots call " finger trouble"

Anyway glad it worked
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Closed Thread

Thread Tools
Display Modes


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 10:29 PM.


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