format excel spreadsheet

by agmccall 3 replies
Hello

I am not at all familiar with formatting an excel spread sheet and need to do a simple task for my Wife.

She has clients, all different, and they need to receive follow up emails. This can not be done through an autoresponder as all clients have different needs and followups.

What I want the spreadsheet to do is. to have a column with date last email sent, next column will have days to send next email, and the next column to have current date. What I want to happen is the current date to be red and to turn green when it is time to send next email

example
email sent 2/1/2016 3 days to next email, current date 2/1/2016(this cell is red)

email sent 2/1/2016 3 days to next email, current date 2/4/2016(this cell is now green)

I hope I explained myself

Thanks in advance

al
#programming #excel #format #spreadsheet
Avatar of Unregistered
Avatar of Unregistered

Trending Topics

  • 99 {{ upvoteCount | shortNum }}

    Warriors .... Warriors.... what would you like to LEARN?

    Good Morning awesome Warriors... I'm happy to announce that The Warrior Forum is planning to create our first COURSE. Yes... Powered by Warrior Wisdom... yeah!! Made at home. But before ... [read more]

  • 83 {{ upvoteCount | shortNum }}

    How I Sold 985 Copies of an Affiliate Offer in 5 Days (Step by Step)

    When I first started online in 2002, it took me a year to sell 985 copies of anything. These days, I can typically do it in the span of a ... [read more]

  • 48 {{ upvoteCount | shortNum }}

    1 Powerful Concept that Grows Your Business

    Connect with people interested in what you have to offer. Mindfully. Versus desperately running from prospect to prospect, or from number to number. This idea sounds simple, and like common ... [read more]

  • 1 {{ upvoteCount | shortNum }}

    I have 5 blogs. Each 900-1100 UV/day

    Hi guys. Quick question. I have 4 blogs. Niches are: education, travel, finance, fitness and health. Each gets traffic for around 900-1100 approximately. I want to sell there ad spaces, ... [read more]

  • 2 {{ upvoteCount | shortNum }}

    Do affiliate niche sites still make money in 2017?

    I know that this concept has been around since the dawn of the internet but does it still work? I am curious. If so is the concept still the same? ... [read more]