I would think you'd want something like:

=$B$2<NOW()

or probably more like:

=$B$2=TODAY()

Does that help?
Paul

--

"Loadmaster" wrote in message
...
I currently have a conditional formatting formula in Cell B2. Condition 1
is
this: Cell Value Is, between, =NOW()+1 and =NOW()+31, formatted yellow.
This
lets me know between 31 to the day before the date that a persons currency
is
about to expire. I also have Condition 2 is this: Formula Is, =$B$2=NOW(),
formatted orange. This lets me know the day it expires. I just need one
more
Conditional 3 formatting formula to turn the cell red when yesterday and
further has past. Can you help me out?