Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting by day of the date in Excel 2003
I use a worksheet for each month to track my bills.
I enter a due date of each bill in Month Day Year eg. 03/14/01. I would like for my date that I would enter to change color if the Day is less than the previous date entered. eg March tab has card due on 03/14/01, and in April the date may be 04/10/01. I would like April date to be Red, for example. Can this be done? Thanks for your responce. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting by day of the date in Excel 2003
Are you saying that if the day of the month is less, you want it to show in
RED? I think I'd use a formula something like this =Day(A1)< Day (A2) Where A1 is last months cell and a2 is this months cell -- HTH, Barb Reinhardt "billz" wrote: I use a worksheet for each month to track my bills. I enter a due date of each bill in Month Day Year eg. 03/14/01. I would like for my date that I would enter to change color if the Day is less than the previous date entered. eg March tab has card due on 03/14/01, and in April the date may be 04/10/01. I would like April date to be Red, for example. Can this be done? Thanks for your responce. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting by day of the date in Excel 2003
I tried:
=Day(AUG!$N$4)< Day (SEP!$N$4) September day was earlier than August day, but I received an error that I can not do it. Error read; You may not use references to other worksheets or workbooks for Conditional Formatting criteria. Strange because I already use valuse from previous worksheets in this file. "Barb Reinhardt" wrote: Are you saying that if the day of the month is less, you want it to show in RED? I think I'd use a formula something like this =Day(A1)< Day (A2) Where A1 is last months cell and a2 is this months cell -- HTH, Barb Reinhardt "billz" wrote: I use a worksheet for each month to track my bills. I enter a due date of each bill in Month Day Year eg. 03/14/01. I would like for my date that I would enter to change color if the Day is less than the previous date entered. eg March tab has card due on 03/14/01, and in April the date may be 04/10/01. I would like April date to be Red, for example. Can this be done? Thanks for your responce. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting by day of the date in Excel 2003
OK, I see the problem now. You'll need to define a workbook level named
range to be able to do this. This named range needs to be defined for the cell that is not on the active sheet. Come back if you need more help. -- HTH, Barb Reinhardt "billz" wrote: I tried: =Day(AUG!$N$4)< Day (SEP!$N$4) September day was earlier than August day, but I received an error that I can not do it. Error read; You may not use references to other worksheets or workbooks for Conditional Formatting criteria. Strange because I already use valuse from previous worksheets in this file. "Barb Reinhardt" wrote: Are you saying that if the day of the month is less, you want it to show in RED? I think I'd use a formula something like this =Day(A1)< Day (A2) Where A1 is last months cell and a2 is this months cell -- HTH, Barb Reinhardt "billz" wrote: I use a worksheet for each month to track my bills. I enter a due date of each bill in Month Day Year eg. 03/14/01. I would like for my date that I would enter to change color if the Day is less than the previous date entered. eg March tab has card due on 03/14/01, and in April the date may be 04/10/01. I would like April date to be Red, for example. Can this be done? Thanks for your responce. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting by day of the date in Excel 2003
SURE.... Thats a mouthful. I figured out how to label a cell, then how to accept labels in formulas, but.... it just drops you off there with no more info on what you do with the labeled formatted cell. the defining part points to 3-D reference. Seems like a lot of work to get a value to change. Looks like I might use a separate cell for just the day. Probably easier to do that. "Barb Reinhardt" wrote: OK, I see the problem now. You'll need to define a workbook level named range to be able to do this. This named range needs to be defined for the cell that is not on the active sheet. Come back if you need more help. -- HTH, Barb Reinhardt "billz" wrote: I tried: =Day(AUG!$N$4)< Day (SEP!$N$4) September day was earlier than August day, but I received an error that I can not do it. Error read; You may not use references to other worksheets or workbooks for Conditional Formatting criteria. Strange because I already use valuse from previous worksheets in this file. "Barb Reinhardt" wrote: Are you saying that if the day of the month is less, you want it to show in RED? I think I'd use a formula something like this =Day(A1)< Day (A2) Where A1 is last months cell and a2 is this months cell -- HTH, Barb Reinhardt "billz" wrote: I use a worksheet for each month to track my bills. I enter a due date of each bill in Month Day Year eg. 03/14/01. I would like for my date that I would enter to change color if the Day is less than the previous date entered. eg March tab has card due on 03/14/01, and in April the date may be 04/10/01. I would like April date to be Red, for example. Can this be done? Thanks for your responce. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting by day of the date in Excel 2003
Try it like this...
Comparing SEP to AUG Select the SEP sheet Select cell N4 FormatConditional Formatting Formula Is: =AND(COUNT(N4),DAY(N4)<DAY(INDIRECT("AUG!N4"))) -- Biff Microsoft Excel MVP "billz" wrote in message ... I use a worksheet for each month to track my bills. I enter a due date of each bill in Month Day Year eg. 03/14/01. I would like for my date that I would enter to change color if the Day is less than the previous date entered. eg March tab has card due on 03/14/01, and in April the date may be 04/10/01. I would like April date to be Red, for example. Can this be done? Thanks for your responce. |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting by day of the date in Excel 2003
That worked.
thankyou much. "T. Valko" wrote: Try it like this... Comparing SEP to AUG Select the SEP sheet Select cell N4 FormatConditional Formatting Formula Is: =AND(COUNT(N4),DAY(N4)<DAY(INDIRECT("AUG!N4"))) -- Biff Microsoft Excel MVP "billz" wrote in message ... I use a worksheet for each month to track my bills. I enter a due date of each bill in Month Day Year eg. 03/14/01. I would like for my date that I would enter to change color if the Day is less than the previous date entered. eg March tab has card due on 03/14/01, and in April the date may be 04/10/01. I would like April date to be Red, for example. Can this be done? Thanks for your responce. |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting by day of the date in Excel 2003
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "billz" wrote in message ... That worked. thankyou much. "T. Valko" wrote: Try it like this... Comparing SEP to AUG Select the SEP sheet Select cell N4 FormatConditional Formatting Formula Is: =AND(COUNT(N4),DAY(N4)<DAY(INDIRECT("AUG!N4"))) -- Biff Microsoft Excel MVP "billz" wrote in message ... I use a worksheet for each month to track my bills. I enter a due date of each bill in Month Day Year eg. 03/14/01. I would like for my date that I would enter to change color if the Day is less than the previous date entered. eg March tab has card due on 03/14/01, and in April the date may be 04/10/01. I would like April date to be Red, for example. Can this be done? Thanks for your responce. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003: Conditional Formatting with Subtotals | Excel Discussion (Misc queries) | |||
Conditional formatting compatibility with excel 2003 | Excel Worksheet Functions | |||
Conditional Formatting: Excel 2003 vs. 2007 | Excel Worksheet Functions | |||
Applying conditional formatting to a workbook in excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003: Conditional Formatting | Excel Discussion (Misc queries) |