Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting, date.
Hi there, I searched thru the posts and found some really good answers to
other questions I have, but I'm still having trouble with one thing. So far I have found only solutions to conditionally formatting dates if they are based off of today's date, i.e., "I want it to turn green a year from now". I have query results pulled from Access that I would like to do a few things. My first column has the date which a work order was last issued. The second column is the date the work order was closed. I would like, for any date listed, if it is longer than 30 days between the dates, for it to turn red. I didn't know how or if I could do this for an entire column, because I have hundreds of dates to compare and it would be illogical for me to format each set of dates individually. I apologize if my question is overstated and the answer is inanely simple, I am really not familiar with Excel formulas. I appreciate your help! -- Aaron Regular, Dissent Records www.nbtnc.com |
#2
|
|||
|
|||
if you first column is A and your second column is B
and you want B to change color when it is more than 30 days after Column A select column B formula is =B1-A130 and set your format Note I often need to go back into the conditinal format to get rid of unwanted quote marks and to correct for conditinal references. "DissentChick" wrote: Hi there, I searched thru the posts and found some really good answers to other questions I have, but I'm still having trouble with one thing. So far I have found only solutions to conditionally formatting dates if they are based off of today's date, i.e., "I want it to turn green a year from now". I have query results pulled from Access that I would like to do a few things. My first column has the date which a work order was last issued. The second column is the date the work order was closed. I would like, for any date listed, if it is longer than 30 days between the dates, for it to turn red. I didn't know how or if I could do this for an entire column, because I have hundreds of dates to compare and it would be illogical for me to format each set of dates individually. I apologize if my question is overstated and the answer is inanely simple, I am really not familiar with Excel formulas. I appreciate your help! -- Aaron Regular, Dissent Records www.nbtnc.com |
#3
|
|||
|
|||
Oh wow, you rock. I feel like such a goob. That's what I get for having my
head buried under Access for months. Thanks so much for your reply! -- Aaron Regular, Dissent Records www.nbtnc.com "bj" wrote: if you first column is A and your second column is B and you want B to change color when it is more than 30 days after Column A select column B formula is =B1-A130 and set your format Note I often need to go back into the conditinal format to get rid of unwanted quote marks and to correct for conditinal references. "DissentChick" wrote: Hi there, I searched thru the posts and found some really good answers to other questions I have, but I'm still having trouble with one thing. So far I have found only solutions to conditionally formatting dates if they are based off of today's date, i.e., "I want it to turn green a year from now". I have query results pulled from Access that I would like to do a few things. My first column has the date which a work order was last issued. The second column is the date the work order was closed. I would like, for any date listed, if it is longer than 30 days between the dates, for it to turn red. I didn't know how or if I could do this for an entire column, because I have hundreds of dates to compare and it would be illogical for me to format each set of dates individually. I apologize if my question is overstated and the answer is inanely simple, I am really not familiar with Excel formulas. I appreciate your help! -- Aaron Regular, Dissent Records www.nbtnc.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting of date | Excel Discussion (Misc queries) | |||
Conditional Formatting Based on Date | Excel Discussion (Misc queries) | |||
How do I set a date range for conditional formatting in a macro? | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) |