format excel spreadsheet

by agmccall

Posted: 8 years ago 3 replies

PROGRAMMING

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

#excel #format #spreadsheet

jasonthewebmaster Banned 8 years ago

I think this tutorial may be exactly what you need: Conditional Formatting Based on Date Proximity (Microsoft Excel)
- Thanks
- 1 reply
{{ DiscussionBoard.errors[10517427].message }}
- Cochel 8 years ago
  
  Originally Posted by jasonthewebmaster
  
  I think this tutorial may be exactly what you need: Conditional Formatting Based on Date Proximity (Microsoft Excel)
  
  I second. That's the closest thing to do.
  
  Thanks
  
  {{ DiscussionBoard.errors[10533116].message }}
David Beroff 7 years ago

Hi, Al,

I realize this is an ancient thread, but I thought that I might chime in with something: I've been getting dynamic status updates using the NOW() function in Google Drive Spreadsheets with great success. The client wants up-to-the-minute status updates, and it's kinda fun watching the collaborative spreadsheet update everything itself.
- Thanks
Signature

Put MY voice on YOUR video: AwesomeAmericanAudio.com
{{ DiscussionBoard.errors[11034616].message }}

format excel spreadsheet

Trending Topics

Newbie

How did you turn it all around?

A healthy fascination for Hollywood...

Any thoughts on golf's latest phenom...Scottie Scheffler??

best high quality crypto traffic.