| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating
How do I conditional format a date?
The date should be thirty one days old when it formats. -- Alexa |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating
If it's about cell A1:
Cond. formatting "Value is" less than today()-31 -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Alexa M." wrote: How do I conditional format a date? The date should be thirty one days old when it formats. -- Alexa |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating
Bad sentence: disregard from: "If it's about cell A1:"
The rest should be OK. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Wigi" wrote: If it's about cell A1: Cond. formatting "Value is" less than today()-31 -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Alexa M." wrote: How do I conditional format a date? The date should be thirty one days old when it formats. -- Alexa |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating
Does this work in the newer version of Excel? If you could you please give
step by step instructions? -- Alexa "Wigi" wrote: Bad sentence: disregard from: "If it's about cell A1:" The rest should be OK. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Wigi" wrote: If it's about cell A1: Cond. formatting "Value is" less than today()-31 -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Alexa M." wrote: How do I conditional format a date? The date should be thirty one days old when it formats. -- Alexa |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating
Also would the if function work in the same way?
-- Alexa "Alexa M." wrote: Does this work in the newer version of Excel? If you could you please give step by step instructions? -- Alexa "Wigi" wrote: Bad sentence: disregard from: "If it's about cell A1:" The rest should be OK. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Wigi" wrote: If it's about cell A1: Cond. formatting "Value is" less than today()-31 -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "Alexa M." wrote: How do I conditional format a date? The date should be thirty one days old when it formats. -- Alexa |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating
I don't quite understand the question. Are you trying to make a date change
format when it is 31 days from day x? Is day x a specific cell reference or is it the current date? -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Alexa M." wrote: How do I conditional format a date? The date should be thirty one days old when it formats. -- Alexa |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating
I want the date to change to red when the invoice (which it really is an
ivoice) is over thrity days old. Which would mean that the customer for the invoice is overdue. I want to see who is over due when I open up the workbook. I don't know I think it would be a cell reference. -- Alexa "M Kan" wrote: I don't quite understand the question. Are you trying to make a date change format when it is 31 days from day x? Is day x a specific cell reference or is it the current date? -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Alexa M." wrote: How do I conditional format a date? The date should be thirty one days old when it formats. -- Alexa |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formating
Try this:
-highlight your column -go to "format" -go to "conditional format" -condition 1: cell Value Is less than today()-31 -go to "format" -choose your font, font color and background color, click "OK" -click "OK" "Alexa M." wrote: I want the date to change to red when the invoice (which it really is an ivoice) is over thrity days old. Which would mean that the customer for the invoice is overdue. I want to see who is over due when I open up the workbook. I don't know I think it would be a cell reference. -- Alexa "M Kan" wrote: I don't quite understand the question. Are you trying to make a date change format when it is 31 days from day x? Is day x a specific cell reference or is it the current date? -- Tips for Excel, Word, PowerPoint and Other Applications http://www.kan.org/tips "Alexa M." wrote: How do I conditional format a date? The date should be thirty one days old when it formats. -- Alexa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating and Mid | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| conditional formating | Excel Worksheet Functions | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Linear Mode
