Date

  • Thread starter ~Alan Rosenberg Miami
  • Start date
A

~Alan Rosenberg Miami

XL2000
Is there away to place tomorrows date in a said cell when I change the
color of another
cell today?
I am using conditional formatting to change the a cell from default to
REd or GREEN based on a fomula.
So lets say today I enter a value in D3 and E3 Turns Red is it possible
to have a tomorrows date entered in A4
and the the next day when I enter a value in D4 and E4 turns green is it
possible to have tomorrows date entered into
A5 and so on
 
F

Fred Smith

What was wrong with the answers you got to your previous post? ie, in A4,
use:

=if(same condition that turns E3 red,today()+1,"")
 
A

~Alan Rosenberg Miami

I am looking for a code that can be place in the sheet code
also this code =if(same condition that turns E3 red,today()+1,"")
refers to E3 that is good for only 1 day since today but I am on E5 today and
monday I will be on E6
Tuesday E7 and so on
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change the colour of a neighbouring cell 6
Transfer data between two tables 3
Excel does not accept text format! 0
Conditional formatting with two columns 0
How to use Today's date in a cell and make it stay the same date 6
Conditional formatting with dates 7
conditional format cells by date 2
several conditional formats for dates 4

Top