Excel Help

[FallenHero]

Is there anyway to make it so that a cell in excel turns red one year after a date is entered into it?

Example would be you took a driving test on 11/13/14 and that date is entered into excel

On 11/13/15, the cell automatically changes to red to indicate that the driving test needs to be re-done and makes it real easy to spot those that need to take the test again?

Also, would there be able to be a warning given with say 30 days out, the cell turns yellow?

I dont mind using multiple sheets if needed, but I would some pointers on getting the fuctions to call the specific cell from a different sheet if needed.

Sorry if this seems basic to some of you, it's been years since I've had to do anything with excel at all.

 

[Ns1]

yes it's possible. Do I know how to do it without copius amounts of googling? nope, but I've definitely seen it done.

 

[CraKaJaX]

Yes - you'll need to use conditional formatting for this (there may be another way, but this is the only way I know of). I believe you may have to create your own rule since you want such a big range (one year). I'm sure throwing something into google for conditional formatting with dates will get you what you're looking for

 

[FallenHero]

Yes - you'll need to use conditional formatting for this (there may be another way, but this is the only way I know of). I believe you may have to create your own rule since you want such a big range (one year). I'm sure throwing something into google for conditional formatting with dates will get you what you're looking for

cool, I'll start there. My google-fu is weak since I didn't even know where to start. If anyone has any specific examples or the exact formula, please post it. 😛

 

[CraKaJaX]

quick Google: http://blogs.office.com/2013/04/04/using-conditional-formatting-to-highlight-dates-in-excel/

 

[skimple]

quick Google: http://blogs.office.com/2013/04/04/using-conditional-formatting-to-highlight-dates-in-excel/

Wow, that was quick! I think somebody owes you a beer.

 

[CraKaJaX]

Wow, that was quick! I think somebody owes you a beer.

I've been at work ~15 mins. That's long enough, right? 😀

 

[rcpratt]

Yeah, conditional formatting. Where A1 is your date:

=TODAY()-A1>=365 (red)
=TODAY()-A1>=335 (yellow)

 

[Tweak155]

Yeah conditional formatting works for this. I usually jump to VBA functions for these sorts of things, but that is overkill in this case.

 

[FallenHero]

Man you guys are awesome. Screw the beer, cocaine for everyone!