30 days to certification expiration conditional formatting not working in table

[blizzardw]

Hello everyone,

I am trying to set up a staff table with their employment info and I want to have their First aid and cpr expiration dates on file. I want to have it so when I open the file I can see who has their First Aid and CPR expiiring in the next 30 days and the others that are past due.

I have tried the conditional formatting of Less than =TODAY()+30 produces YELLOW cell, Less than =TODAY() produces RED cell. After that, the tutorial I watched said to use another condition where =IFBLANK(L1)=TRUE will produce WHITE fill. When I try this the blank cells are all red still...

Is there a difference when doing this in a table?

Thanks for any help!

[Special-K]

Select the range to highlight, I'm assuming the first cell is A1 and the highlighted range is A1:A100.

Conditional Formatting
New Rule
Use a formula to determine...
2 formulas needed one for yellow, one for red.

=AND(A1<>0,A1<=TODAY()+30)
format as yellow

=AND(A1<>0,A1<=TODAY())
format as red

If you don't put A1<>0 in then any cells which do not have dates int hem will be considered to be <= TODAY and will colour cells incorrectly.