Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting dates
Hey guy's,
I have sheet with some data for employe info. One column Is there ID's expire date In this column I need to use the conditional formatting to make alert by green color before 2 month of the expire date and the yellow color before one month and from the expire date and up till today getting red. Please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting dates
Hi,
I have sheet with some data for employe info. One column Is there ID's expire date In this column I need to use the conditional formatting to make alert by green color before 2 month of the expire date and the yellow color before one month and from the expire date and up till today getting red. which version of Excel do you use? Maybe, this article will help you: http://www.techonthenet.com/excel/qu...rmat4_2010.php -- Cheers, Lisa |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting dates
On Tuesday, December 10, 2013 7:17:49 PM UTC+3, Lisa Wilke-Thissen wrote:
Hi, I have sheet with some data for employe info. One column Is there ID's expire date In this column I need to use the conditional formatting to make alert by green color before 2 month of the expire date and the yellow color before one month and from the expire date and up till today getting red. which version of Excel do you use? Maybe, this article will help you: http://www.techonthenet.com/excel/qu...rmat4_2010.php -- Cheers, Lisa Sorry but i need the expire dates which is written in the column it self, not today date |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting dates
Hi,
[http://www.techonthenet.com/excel/qu...mat4_2010.php] Sorry but i need the expire dates which is written in the column it self, not today date But the number of days between today's date and expire dates is important, isnt it? 1. Cell Value is less than or equal to =Today() Format: Red 2. Cell Value is between =Today() and =Today()+30 Format: Yellow 3. Cell Value is greater than or equal to = Today()+60 -- Cheers, Lisa |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting - Dates | Excel Worksheet Functions | |||
conditional formatting dates | Excel Worksheet Functions | |||
Conditional formatting with dates | Excel Discussion (Misc queries) | |||
dates and conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting & Dates? | Excel Discussion (Misc queries) |