How do I create a task from conditional formatting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top