Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function and Color Code
Hello I am hoping someone can help me out. I am trying to perform the
following. The first column of my worksheet is a date. I would like to have my ROWS color coded depending on the date in the first column. If the date is from 0-3 months from NOW then color green. Any ideas. Thanks much! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function and Color Code
Conditional Formatting
=AND(A1=TODAY(),A1<=DATE(YEAR(TODAY()),MONTH(TODA Y())+3,DAY(TODAY()) "JEN1752" wrote: Hello I am hoping someone can help me out. I am trying to perform the following. The first column of my worksheet is a date. I would like to have my ROWS color coded depending on the date in the first column. If the date is from 0-3 months from NOW then color green. Any ideas. Thanks much! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Function and Color Code
Format/ Conditional Formatting/ Formula is:
=AND($A10TODAY(),$A10<DATE(YEAR(TODAY()),MONTH(TO DAY())+3,DAY(TODAY()))) Choose format accordingly -- David Biddulph "JEN1752" wrote in message oups.com... Hello I am hoping someone can help me out. I am trying to perform the following. The first column of my worksheet is a date. I would like to have my ROWS color coded depending on the date in the first column. If the date is from 0-3 months from NOW then color green. Any ideas. Thanks much! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|