Search results

WOW ! My work is done ! Just like that Luke M. Thank You, The link to the fill-blank-cells-in-a-table didnt work the first time as I was reading it relatively and didnt update the formula to change MY cell above! what a clutz. In my strive to learn, I tried out SirJB7's helper column...

Indeed, "nothing is free" in this world. I do respect those who help others on these forums, This particular avenue I find myself wandering is full of assistance of which I am very appreciative I can assure you.

Good afternoon all, I'm loving the forums btw. learning oodles. Here's the thing, I have a s/s with about 6000 rows. It records occurences in date order. Column A is the date Column B thru to AY contains other stuff ! Every Row should have a date in column A. There could be 10 entries on one...

@Hui (what does the @ do ?) Sorry wasnt aware of that Im new to pulbic blogs etc. my apologies i will in future advise you all on here whenever that happens again. Obviously it wont now. :D

WELL! You all let me down. ! :( I got the answer elsewhere. i now have what i need thanks anyway. bye for now.

Wintermute, Thanks for the comment !. this is what I'm trying to do. but cannot get the syntax correct. This is why I'm asking for the correct syntax. you are answering my post with too much asumption that I know what I'm doing (sorry if i came across like that :)

Hi Indian, Yes stop date is the same as expiry date. sorry. These cells should turn to appropriate colour as the stop date approaches. i.e. green to yellow greater than 90 days to 11, then yellow to Red from 10 days to current date (once the current date has been reached it will remain red)...

Good Afternoon Guru's & Ninja’s This is my first Post (probably not my last!) I would start this of all innocent like, but I won’t. I do have some experience in excel and have done a 2 day course in VBA but seeing as there is no-one to mentor me at the moment I have forgotten some of it...