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