Highlighting a cell when say it expires, like 1st aid no longer valid so cell will hilite?

[Deev1ant]

Hello all. I am having an issue when I want to say highlite a cell when for example certain certification has expired. Say employee X has valid first aid but it expires in 22 days, how do I get the cell to highlite that so if/when it expires the cell will change color letting the powers that be know about it?? I looked at a few examples and I am confused as most of them have the date in the doc they are using, but mine does not have the date. Will I have to add it? Any help is appreciated. I can send you the xls if need be to give a better understanding of what I mean. Thanks...

DEEV

[FDibbins]

if you are familiar with conditional formatting, in the cell you want to have the color changed, reference the first aid expiry date and use this, assuming the high-lighted cell is A1, and the date you are testing against is in B1...
=B1<TODAY()-22
format as needed

let me know if that works for you?

[Deev1ant]

Thanks for quick response. I cannot wrap my head around how excel knows the date and if I would need to enter that somewhere. I figure all I really need is for it to let my powers that be know when say our first aid is up for renewal or even expired. The rest of the courses we take have no expiration. I can send you the xls if need be as well, to maybe get a better idea of what I am asking?

Oh yah we are still using 2003 if that helps...tks.

[FDibbins]

ok so how do you know when it has expired if there is no date there to tell you that?