Yesterday
 

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?

Yesterday
 

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?

Yesterday
 

Maybe

=TODAY()-1=A1

Mike

"Loadmaster" wrote:

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?

Yesterday
 

Loadmaster wrote:
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?

If you have just a date in B2, you should be using the TODAY() function.

Three conditional formatting conditions for B2 as follows:

Cell Value Is between =TODAY()+1 and =TODAY()+31
Format YELLOW

Cell Value Is equal to =TODAY()
Format ORANGE

Cell Value Is less than =TODAY()
Format RED

Yesterday
 

Thank-you, it worked

"Glenn" wrote:

Loadmaster wrote:
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?

If you have just a date in B2, you should be using the TODAY() function.

Three conditional formatting conditions for B2 as follows:

Cell Value Is between =TODAY()+1 and =TODAY()+31
Format YELLOW

Cell Value Is equal to =TODAY()
Format ORANGE

Cell Value Is less than =TODAY()
Format RED

Yesterday
 

Thank-you, it worked


"Glenn" wrote:

Loadmaster wrote:
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?

If you have just a date in B2, you should be using the TODAY() function.

Three conditional formatting conditions for B2 as follows:

Cell Value Is between =TODAY()+1 and =TODAY()+31
Format YELLOW

Cell Value Is equal to =TODAY()
Format ORANGE

Cell Value Is less than =TODAY()
Format RED