Excel 2007 : Formulas based on cell color

[Jhawth]

I have an excel workbook that has about 2,000 rows. Data is in columns A to AK in all 2,000 rows. Certain rows are certain colors. Is there a way to create a formulas that states, for example, if cell P3 is red – dump number here:confused :?

[alansidman]

This tutorial may give you an idea or two on how to accomplish what you want.

http://www.datapigtechnologies.com/f...rtonColor.html

Alan

[blizz]

pardon me if i'm intruding, but i have a smiliar question.,.. i have 12 sheets... items turn red when overdue on said sheets...

when they turn red... is there a formula that will dump them into sheet 13 (all overdues)?

EDIT: on a gov't computer... cant stream video.

[Jhawth]

Thanks! This at least points me in the right direction.

[alansidman]

Blizz:
Suggest you view on another machine. To complex to explain in forum.

Alan