Yesterday

L

Loadmaster

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?
 
P

PCLIVE

I would think you'd want something like:

=$B$2<NOW()

or probably more like:

=$B$2=TODAY()

Does that help?
Paul
 
G

Glenn

Loadmaster said:
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?
Click to expand...

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
 
L

Loadmaster

Thank-you, it worked

Glenn said:
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
Click to expand...
 
L

Loadmaster

Thank-you, it worked


Glenn said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditoinal formatting 2
conditional formatting update issue 5
Conditional Formatting - Number Format 8
Conditional formatting dates 3
Changing cell colors from a function command 3
Colors according to the month 3
Conditional Formatting Intermittent at best 1
IF OR AND in same conditional formula 2

Top