software

Hi

I’m making a spreadsheet that is conditionally formatted to highlight
any companies names in a database that my company is due to contact,
based on a formula working out the gap between today’s date and the
date when we said we thought we should next contact them, and if that
date is less than one then the company gets highlighted in red. I also
want a box to come up when the spreadsheet is started stating which
companies should be contact, saving the user from scrolling down the
screen unless they want to. Any ideas how I’d go about doing this? I
assume I need to link a caption box (as I need it to be closeable)
through to a similar formula as with the highlighting, but I have no
idea how to get text to display in one? Thanks for your help guys and
girls.--
mr_chrisevans
------------------------------------------------------------------------
mr_chrisevans's Profile: www.excelforum.com/member.php...oamp;userid=30310
View this thread: www.excelforum.com/showthread...hreadid=500088mr_chrisevans,

Assuming you already have the quot;Lastquot; contacted date and the quot;Nextquot; contact
date, would it not be an idea to create a quot;Duequot; to be contacted column and
then have the spreadsheet quot;AutoFilterquot; on open to show all those that are
quot;Duequot; to be contacted?
Hence only listing the ones to be contacted!

Dean

quot;mr_chrisevansquot; wrote:

gt;
gt; Hi
gt;
gt; I’m making a spreadsheet that is conditionally formatted to highlight
gt; any companies names in a database that my company is due to contact,
gt; based on a formula working out the gap between today’s date and the
gt; date when we said we thought we should next contact them, and if that
gt; date is less than one then the company gets highlighted in red. I also
gt; want a box to come up when the spreadsheet is started stating which
gt; companies should be contact, saving the user from scrolling down the
gt; screen unless they want to. Any ideas how I’d go about doing this? I
gt; assume I need to link a caption box (as I need it to be closeable)
gt; through to a similar formula as with the highlighting, but I have no
gt; idea how to get text to display in one? Thanks for your help guys and
gt; girls.
gt;
gt;
gt; --
gt; mr_chrisevans
gt; ------------------------------------------------------------------------
gt; mr_chrisevans's Profile: www.excelforum.com/member.php...oamp;userid=30310
gt; View this thread: www.excelforum.com/showthread...hreadid=500088
gt;
gt;