B
brivera
what would a formula look like that compares differnt dates (different cells)
to one specific date, please?
to one specific date, please?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Bernie Deitrick
If the specific date is in cell A1, reference using absolute referencing:
=IF(B1>$A$1,B1,"")
If the date is not in a cell, you could use
=IF(B1>DATEVALUE("July 10, 2009"),B1,"")
Other than that, your question is a bit fuzzy around the edges...
HTH,
Bernie
MS Excel MVP
=IF(B1>$A$1,B1,"")
If the date is not in a cell, you could use
=IF(B1>DATEVALUE("July 10, 2009"),B1,"")
Other than that, your question is a bit fuzzy around the edges...
HTH,
Bernie
MS Excel MVP
B
Bernie Deitrick
Oh... and with Conditional Formatting, the Formula is option could use a
formula like
=B1>$A$1
A better explanation of what you want to do would help us help you.
Bernie
MS Excel MVP
formula like
=B1>$A$1
A better explanation of what you want to do would help us help you.
Bernie
MS Excel MVP
T
T. Valko
You need to be more specific.
What kind of comparison? Greater than? Less than? Equal? Same month? Same
year? Leap year?
Where are the dates you want to compare?
And most importantly, what should happen when the dates are compared? Your
subject line says conditional formatting so I'm assuming you might want to
change cell colors or something along those lines.
compares differnt dates
What kind of comparison? Greater than? Less than? Equal? Same month? Same
year? Leap year?
Where are the dates you want to compare?
And most importantly, what should happen when the dates are compared? Your
subject line says conditional formatting so I'm assuming you might want to
change cell colors or something along those lines.
S
Shane Devenshire
Suppose you want to change the fill color of all cells whose date is equal to
the date in cell C1. Suppose all those dates are in the range A1:A100
To conditionally format your cell(s):
In 2003:
1. Select the cells you want to format, A1:A100 in this example
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=A1=$C$1
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.
In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=A1=$C$1
5. Click the Format button and choose a format.
6. Click OK twice
the date in cell C1. Suppose all those dates are in the range A1:A100
To conditionally format your cell(s):
In 2003:
1. Select the cells you want to format, A1:A100 in this example
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=A1=$C$1
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.
In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=A1=$C$1
5. Click the Format button and choose a format.
6. Click OK twice