Hi

I'm trying to apply conditional formatting (shade a range of 4 colums x 25
lines) based on the days an order took to be delivered.
- If DateOrdered to DateDelivered took longer than 30 days (or is still
outstanding), shade red.
- If DateOrdered to DateDelivered took shorter than 30 days, shade green.

I've tried recording a macro for some guidance, but have difficulty with the
calculation first part. Tried adding a "calculate days outstanding" column,
but then get #Value! error when order is not yet delivered.

Would appreciate some guidance. I'm still reading Walkenbach's VBA for
Dummies...

Thanks a lot.