| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning Yesterday | Excel Worksheet Functions | |||
| Please can someone look at question i posted yesterday | Excel Worksheet Functions | |||
| I really need help. Need a formula. Need it yesterday. | New Users to Excel | |||
| continuation from yesterday | Excel Discussion (Misc queries) | |||
| Need absolute time from yesterday | Excel Worksheet Functions | |||
Linear Mode
