highlight the entire row of current cell

cwksr · #1 12-01-2014, 03:06 AM

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.

BobBridges · #2 12-01-2014, 07:23 AM

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.

Pecoflyer · #3 12-02-2014, 10:27 AM

Quote:

Originally Posted by cwksr

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

cwksr · #4 12-02-2014, 11:02 AM

I did use the a4.....but posted before I re-read

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