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: http://www.excelforum.com/member.php...o&userid=30310
View this thread: http://www.excelforum.com/showthread...hreadid=500088

mr_chrisevans,

Assuming you already have the "Last" contacted date and the "Next" contact
date, would it not be an idea to create a "Due" to be contacted column and
then have the spreadsheet "AutoFilter" on open to show all those that are
"Due" to be contacted?
Hence only listing the ones to be contacted!

Dean

"mr_chrisevans" wrote:


Hi

Im 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 todays 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 Id 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: http://www.excelforum.com/member.php...o&userid=30310
View this thread: http://www.excelforum.com/showthread...hreadid=500088