Column A = Dates in ascending order
Im after the code for searching this coloumn for 8 dates i have listed elsewhere and then i would like it to apply rose colour just to the dates in column a.
happy with below but obviously how do i link with specified dates?
Please Login or Register to view this content.
Last edited by VBA Noob; 10-06-2007 at 12:31 PM.
You seem to be looking for a VBA programming solution, for which a better place to post would be the VBA programming forum.
However, would it not be possible to solve your problem using a conditional format?
On the main toolbar select:
Format>Conditional Formatting...
Set the Condition to:
Formula Is
Then type the following formula into the neighbouring box:
ISNUMBER(MATCH(A9,D$1:D$8,0))
Note: you will have to change the cell addresses.
A9 is the current cell, in other words the cell where you want to change the format.
D1 to D8 are the cells where you have the 8 reference dates. .
Finally press the Format... button and choose an appropriate format.
Now use the format painter to copy the format into all the other cells you want.
Mark.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks