#16
|
|||
|
|||
Perfect...thanks both for the answers!
|
#17
|
|||
|
|||
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
|
||||
|
||||
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") |
#19
|
|||
|
|||
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
|
||||
|
||||
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
|
|||
|
|||
try this
here...i'm trying to highlight using whatever can be used, the entire row of "today".
thanks.. |
#22
|
||||
|
||||
Quote:
__________________
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
|
|||
|
|||
it was typographical error
I did use the a4.....but posted before I re-read
|
#24
|
||||
|
||||
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
|
|||
|
|||
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
|
||||
|
||||
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
|
||||
|
||||
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
|
|||
|
|||
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
|
|||
|
|||
Yes, in fact it did work
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
|
||||
|
||||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
How to highlight the row based on cell value? | Learner7 | Excel | 1 | 12-11-2011 02:28 AM |
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 |