![]() |
|
#1
|
|||
|
|||
![]() Perfect...thanks both for the answers! |
#2
|
|||
|
|||
![]()
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. |
#3
|
||||
|
||||
![]()
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") |
#4
|
||||
|
||||
![]() Quote:
__________________
Using O365 v2503 - 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 |
#5
|
|||
|
|||
![]()
I did use the a4.....but posted before I re-read
|
#6
|
|||
|
|||
![]()
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.
|
#7
|
||||
|
||||
![]()
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.
|
#8
|
|||
|
|||
![]()
here...i'm trying to highlight using whatever can be used, the entire row of "today".
thanks.. |
#9
|
||||
|
||||
![]()
To apply the CF you must first choose the entire range $A$4:$Y$368 THEN apply the CF to that range.
HTH
__________________
Using O365 v2503 - 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 |
#10
|
|||
|
|||
![]()
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.
|
#11
|
||||
|
||||
![]()
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.
|
#12
|
||||
|
||||
![]()
Did it not work in the sheet I posted?
__________________
Using O365 v2503 - 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 |
#13
|
|||
|
|||
![]()
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. |
#14
|
|||
|
|||
![]() 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. |
#15
|
||||
|
||||
![]()
Perhaps that's what we pilots call " finger trouble"
![]() Anyway glad it worked
__________________
Using O365 v2503 - 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 |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
Learner7 | Excel | 1 | 12-11-2011 02:28 AM |
![]() |
Johnny thunder | Word VBA | 3 | 04-07-2011 04:44 PM |
highlight cell after checkbox | flatk | Word | 0 | 01-25-2007 12:32 PM |