Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula help
Hello,
date: 01/01/2005 If date is expired beyon 01/01/2005 , what I'd like to see is that, it changes to color red. Is is possible to create this formular? Thanks, Sothea |
#2
|
|||
|
|||
in a single cell:
Format, Conditional Formatting "Cell Value is", "Less than" Enter 1/1/2005 in the third box (better yet, for a dynamic highlight, give it a fixed cell reference [eg '=$A$1' then enter 1/1/2005 at A1). Change your font and background to suit. If you have the format painter showing, use it to paint the format on all cells you want showing this way. Otherwise use Copy, Paste Special, Formats. HTH Steve "Soth" wrote in message ... Hello, date: 01/01/2005 If date is expired beyon 01/01/2005 , what I'd like to see is that, it changes to color red. Is is possible to create this formular? Thanks, Sothea |
#3
|
|||
|
|||
Soth
FormatConditional FormattingFormula is: =A1DATEVALUE("01/01/2005") Pick a red color from the FormatPatterns and OK your way out. Gord Dibben Excel MVP On Thu, 24 Feb 2005 13:17:07 -0800, "Soth" wrote: Hello, date: 01/01/2005 If date is expired beyon 01/01/2005 , what I'd like to see is that, it changes to color red. Is is possible to create this formular? Thanks, Sothea |
#4
|
|||
|
|||
Gord
I didn't find the need for datevalue, Excel recognised and changed 1/1/2005 into a dateserial. Does autoformattng handle it differently in different versions? Steve "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Soth FormatConditional FormattingFormula is: =A1DATEVALUE("01/01/2005") Pick a red color from the FormatPatterns and OK your way out. Gord Dibben Excel MVP On Thu, 24 Feb 2005 13:17:07 -0800, "Soth" wrote: Hello, date: 01/01/2005 If date is expired beyon 01/01/2005 , what I'd like to see is that, it changes to color red. Is is possible to create this formular? Thanks, Sothea |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |