How do I create a task from conditional formatting?

[Guest]

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.

 

[Joerg]

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