View Single Post
 
Old 12-02-2014, 10:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,943
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
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, 11 views)
__________________
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