|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 8th, 2008, 07:55 PM
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
August 8th, 2008, 08:20 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Yesterday
I would think you'd want something like:
=$B$2NOW() 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
August 8th, 2008, 08:26 PM
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
August 8th, 2008, 08:29 PM
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
August 8th, 2008, 09:38 PM
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
August 8th, 2008, 09:41 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
