Date

  • Thread starter Thread starter ~Alan Rosenberg Miami
  • Start date 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
 
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,"")
 
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
 
Back
Top