How can you use colors as a result in a formula, i.e. color a cell red when
30 days from due date, color green when task accomplished.

Hi,

For example, I suggest you input a date in A1 as a due date, then go to
"Format --> Conditional Formatting --> choose Formula Is in condition 1 -->
type =NOW()-A1>30 --> choose format button --> select Pattern tab --> choose
colour red --> OK --> OK.

So, if today's date is more than 30 days the date in A1, the cell will
change to colour red.

The same procedure applies to your second question if you input "Y" in A1
for accomplished task.

HTH

"mckairborne" wrote:

> How can you use colors as a result in a formula, i.e. color a cell red when
> 30 days from due date, color green when task accomplished.

See http://xldynamic.com/source/xld.CF.html

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mckairborne" <(E-Mail Removed)> wrote in message
news7700250-BAA2-4E74-8D63-(E-Mail Removed)...
> How can you use colors as a result in a formula, i.e. color a cell red
when
> 30 days from due date, color green when task accomplished.