Conditional Formatting

[ZombieHuckFinn]

I am trying to figure out how to set up a conditional formatting formula that will highlight values in a column if they are 179 days past TODAY(). I figured out how to do it for each individual column but there are 400+ entries and I assume a conditional formula will be the easiest route.

 

[Matty]

Yes. However this still runs into the issue of using only the date in D2. I need it to use D2, D3... all the way to D361 so that each time it tries to format the cell it references the cell it's formatting, not just D2.

Conditional Formatting in Excel 2007 doesn't work like that. Unless you anchor the Cell address (which I didn't - note that it's D2 not D$2), it will reference the relative Cell.

Are you not seeing the expected results? If not, could you clarify what you want again, perhaps by means of a small example?

Matty

 

[ZombieHuckFinn]

Column D is how it appears now. The range goes from D2:D361. Column F is how I want the formula to format each cell in the range. So the formula you came up with references only D2 when I want it to look at each cell individually and format based on the contents of the cell.

 

[Matty]

The solution I provided does just that.

Are your dates "real" dates, i.e. numbers? What does this formula return?

=ISNUMBER(D2)

Matty

 

[ZombieHuckFinn]

It returns TRUE. Okay I got what the issue was... D$2 vs. $D$2 vs. $D2
Thanks for sticking with me through the ridiculousness...

 

[Joe4]

You're not teaching me to fish... you're throwing fish at me.

Did you thoruoghly read the linkI provided in post #2? If you were truly interested in learning how to fish, I believe you would have found that most useful. Chip does an excellent job of breaking things down and explaining them.

My follow-up reply was in direct relation to the question you asked. If that was not what you were looking for, perhaps you question wasn't all that clear.

I see that you are a new member here. Kristy (Von Pookie) posts some helpful tips on how to post good, complete questions that will help lead to the answers you are looking for. See tips 10-17 here: http://www.mrexcel.com/forum/showthread.php?t=127080