add color or picture to a cell using a formula
 

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.

add color or picture to a cell using a formula
 

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()-A130 -- 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.

add color or picture to a cell using a formula
 

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

--
HTH

Bob Phillips

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

"mckairborne" wrote in message
...
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.