hi
yes
cell value is.....less than......=now()
pick your color.

Regards
FSt1

"Carla" wrote:

Hi,

I have a spreadsheet that lists work orders. I was wondering if I could use
conditional formatting to flag any cells that are in past as of the date that
you open the spreadsheet.

Can this be done fairly easily?