| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting referencing date of expiration
I'm trying to apply conditional formatting to a cell, to show it has expired
when today's date equals the date of expiration. I have the =today() formula in a cell for reference, however the conditional formatting changes immediately even though the two cells are not equal.. What am i doing wrong?? example: cell A2 is the date of expiration- 7-1-2012 cell G5 is today's date- 8-15-2008 when they are equal to each other, the conditional formatting should apply. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting referencing date of expiration
Try this:
Select cell A2 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box on the right: =A2=$G$5 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "FIRE GIRL" wrote in message ... I'm trying to apply conditional formatting to a cell, to show it has expired when today's date equals the date of expiration. I have the =today() formula in a cell for reference, however the conditional formatting changes immediately even though the two cells are not equal.. What am i doing wrong?? example: cell A2 is the date of expiration- 7-1-2012 cell G5 is today's date- 8-15-2008 when they are equal to each other, the conditional formatting should apply. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting referencing date of expiration
Okay, that worked! but my next problem... it is only applying the formula if
the dates are EXACTLY the same... can i make it so if it is today or any day AFTER today it will continue the formatting?? "T. Valko" wrote: Try this: Select cell A2 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box on the right: =A2=$G$5 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "FIRE GIRL" wrote in message ... I'm trying to apply conditional formatting to a cell, to show it has expired when today's date equals the date of expiration. I have the =today() formula in a cell for reference, however the conditional formatting changes immediately even though the two cells are not equal.. What am i doing wrong?? example: cell A2 is the date of expiration- 7-1-2012 cell G5 is today's date- 8-15-2008 when they are equal to each other, the conditional formatting should apply. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting referencing date of expiration
If I understand, change the formula to:
=A2<=$G$5 -- Biff Microsoft Excel MVP "FIRE GIRL" wrote in message ... Okay, that worked! but my next problem... it is only applying the formula if the dates are EXACTLY the same... can i make it so if it is today or any day AFTER today it will continue the formatting?? "T. Valko" wrote: Try this: Select cell A2 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box on the right: =A2=$G$5 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "FIRE GIRL" wrote in message ... I'm trying to apply conditional formatting to a cell, to show it has expired when today's date equals the date of expiration. I have the =today() formula in a cell for reference, however the conditional formatting changes immediately even though the two cells are not equal.. What am i doing wrong?? example: cell A2 is the date of expiration- 7-1-2012 cell G5 is today's date- 8-15-2008 when they are equal to each other, the conditional formatting should apply. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting referencing date of expiration
THAT WORKED!!!
THANK YOU! Any chance you have a 'cheat sheet' for formulas handy or know where i can find one? :-) "T. Valko" wrote: If I understand, change the formula to: =A2<=$G$5 -- Biff Microsoft Excel MVP "FIRE GIRL" wrote in message ... Okay, that worked! but my next problem... it is only applying the formula if the dates are EXACTLY the same... can i make it so if it is today or any day AFTER today it will continue the formatting?? "T. Valko" wrote: Try this: Select cell A2 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box on the right: =A2=$G$5 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "FIRE GIRL" wrote in message ... I'm trying to apply conditional formatting to a cell, to show it has expired when today's date equals the date of expiration. I have the =today() formula in a cell for reference, however the conditional formatting changes immediately even though the two cells are not equal.. What am i doing wrong?? example: cell A2 is the date of expiration- 7-1-2012 cell G5 is today's date- 8-15-2008 when they are equal to each other, the conditional formatting should apply. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Conditional formatting referencing date of expiration
You're welcome!
Any chance you have a 'cheat sheet' for formulas handy or know where i can find one? Maybe this: http://homepage.ntlworld.com/noneley/ I do something similar except I keep a library of formulas in separate files and I tend to only "catalogue" the really complex formulas. Right now I have 349 sample files and each file contains dozens of formula variations. One of these days I'd like to compile all these formulas into a book or do something similar to what Peter did. -- Biff Microsoft Excel MVP "FIRE GIRL" wrote in message ... THAT WORKED!!! THANK YOU! Any chance you have a 'cheat sheet' for formulas handy or know where i can find one? :-) "T. Valko" wrote: If I understand, change the formula to: =A2<=$G$5 -- Biff Microsoft Excel MVP "FIRE GIRL" wrote in message ... Okay, that worked! but my next problem... it is only applying the formula if the dates are EXACTLY the same... can i make it so if it is today or any day AFTER today it will continue the formatting?? "T. Valko" wrote: Try this: Select cell A2 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the little box on the right: =A2=$G$5 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "FIRE GIRL" wrote in message ... I'm trying to apply conditional formatting to a cell, to show it has expired when today's date equals the date of expiration. I have the =today() formula in a cell for reference, however the conditional formatting changes immediately even though the two cells are not equal.. What am i doing wrong?? example: cell A2 is the date of expiration- 7-1-2012 cell G5 is today's date- 8-15-2008 when they are equal to each other, the conditional formatting should apply. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formula: time to expiration date becomes < 6 months | Excel Worksheet Functions | |||
| Conditional Format for a date 1 month before Expiration in Excel 2 | Excel Worksheet Functions | |||
| Retaining date formatting in referencing cell | Excel Discussion (Misc queries) | |||
| Cell Referencing problem when copying conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formate:show by color when expiration dates are overdu | Excel Discussion (Misc queries) | |||
![FIRE GIRL[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
