How do I create a task from conditional formatting?
 

Hi I'm trying to have Outlook open my Excel worksheet and look at it to see
if any of my conditional formatting has been accoplished and if it does take
2 or 3 cells worth of data and create a task. I have a maintenance work
sheet that has certain things due in certain amounts of days for a fleet of
vehicles, and when one is due that particular thing to create a task to
update to my pda.

How do I create a task from conditional formatting?
 

You can only check for the default or manual set formats of cells, not the
formats attributed via conditional formatting. But you could add a helper
column to your worksheet with a formula reproducing the conditional format,
resulting in a cell value depending on condition. You could then check this
cell value with Outlook.

Joerg


"Nick" wrote in message
...
Hi I'm trying to have Outlook open my Excel worksheet and look at it to
see
if any of my conditional formatting has been accoplished and if it does
take
2 or 3 cells worth of data and create a task. I have a maintenance work
sheet that has certain things due in certain amounts of days for a fleet
of
vehicles, and when one is due that particular thing to create a task to
update to my pda.