Calculation according to Color Coding??

[barkaroo]

I have a spreadsheet where I track reviews and the names are color coded. (See below)

Color Coding:
White: due in 3 months
Yellow: due in 6 months
Orange: due in 12 months

If a review is done on Oct 23-07 (variable) and the color of the name cell is yellow, then the next review will be due on April 23-08. I need a formula to look at the name cell and calculate the next review date based on the color of the cell. Can this be done??? (The result will be an EDATE calculation.)

I have attached a pic of the spreadsheet.

Any help would be appreciated.

Thanks.

[shg]

It would be better to do it in reverse fashion; calculate the next review date, and use conditional formatting based on that result.

[barkaroo]

I need the color coding to determine the calculation not the reverse...

It would be better to do it in reverse fashion; calculate the next review date, and use conditional formatting based on that result.

[shg]

It would require VBA to do this (or an XLM Macro), and changing the color would not cause the date to be recalculated (changing a cell color does not generate an event that can be trapped).

So if the color means something (i.e., yellow means review every six months, white means 3 mos, and rose means annually, as your example suggests), then you might instead put that info in a column, and used it to both conditionally format the cell to a color and compute the review date.

[barkaroo]

Thanks, I'll try that instead.

R

It would require VBA to do this (or an XLM Macro), and changing the color would not cause the date to be recalculated (changing a cell color does not generate an event that can be trapped).

So if the color means something (i.e., yellow means review every six months, white means 3 mos, and rose means annually, as your example suggests), then you might instead put that info in a column, and used it to both conditionally format the cell to a color and compute the review date.