If E9 Is red then place tommorrows date in A11

[~Alan Rosenberg Miami]

XL-2000 Is there a formula that can
If E9 Is red then place tomorrow's date in A11
or If E9 Is green then place tomorrow's date in A11

 

[Gord Dibben]

Allan

Is this a typo or did you mean "if E9 is green or red place tomorrow's date in
A11"?

Perhaps one of the "tomorrows" should be "today".

How does E9 get to be green or red? Conditional Formatting? If so, use the
same condition in a formula in A11.

If you manually format E9 to be green or red, you will have to use VBA to
return whichever date in A11.

Some more detail maybe?

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[~Alan Rosenberg Miami]

E9 get to be green or red by Conditional Formatting.
one of the "tomorrows" cant be today since today is already there.
VBA is ok i guess i can put it in the sheet code if i knew how