On Apr 25, 10:06*am, Carla wrote:
THANKS!

Now how about if the date in the cell in column G is less than today and
there isn't any entry in another cell in column B??



"FSt1" wrote:
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?- Hide quoted text -

- Show quoted text -


You will need a helper column. In this helper column put this
conditional formatting. Put in as Formula =.
=AND(Cell value<TODAY(),$G$X=0)
You can not formatt a cell based on current value and the value of
another cell at the same time.

Jay