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
 

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

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel Formatting with dates 3
Excel High lightng dates in future, today and past 1
several conditional formats for dates 4
Conditional unlock for cells 2
Help on IF condition 4
Can't change the cell back to blank when there is a date in it. 0
conditional format cells by date 2

Back
Top