Conditional Formatting

[Lids]

Good afternoon all,

I am using Excel 2013, I was tasked with tracking the employees training records in which I have created an excel worksheet.
My problems are with each training has a different due month. Starting with 1/1/2016, I am working on the 4 training due for the month of Jan. The steps below are what I have done thus far, and unable to yield the desired results. If anyone can please share assistance, it will be greatly appreciated. tks

Assuming we are starting on 1/1/2016

a. Highlighted all the cells associated with Jan training for each employee: Cell ranges are C33-E33 & F32-R32

b. Conditional formatting New Rule #1 (When the dates between 1/1/2016 to 1/31/2016 are entered in a cell it will automatically turn green) indicating the training is current
b1. "Format only cells that contain" "Cell Value" "equal to" =TODAY()

c. Conditional formatting New Rule #2 (All empty cells will automatically turn yellow 7 days before the end of the month on Jan 25) indicating a 7 day window to past due
c1. "Format only cells that contain" "Cell Value" "between" =TODAY()-24 and =TODAY()+24

d. Conditional formatting New Rule #3 (All empty cells will turn red on 2/1/2016) indicating that January Example of Worksheet.xlsxtraining is past due
d1. Format only cells that contain" "Cell Value" "between" =TODAY()-32 and =TODAY()+32

I have also played around with these formulas but none appears to be working

Current: =AND(ISNUMBER($C33),$C33-TODAY()<=1)
Approaching =AND(C33<>"",TODAY()-C33<7)
Past Due =AND(C33<>"",TODAY()-C33>32)

Any and all assistance rendered will be greatly appreciated. Thanking you in advance for your timely responses to my inquiries. Have a great day.

[FDibbins]

Hi, welcome to the forum

It would help a lot if you could upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

Apologies, I just saw your upload hidden in the text - looking at it now

[FDibbins]

OK, just looking, it appears as if you have the references out of sync. Your CF rule starts in column D, but the 2 formula rules reference column C. Try fixing that and see how you make out?

[Lids]

Hi FDibbins,

Thank you and for your responses. I am slightly lost with your response, I do not see where the CF rule starts in column D, I have enclosed an additional attachment with how the worksheet should look.

If any dates between 1/1/2016 0 1/31/2016 is entered, the cell will automatically turn green indicating the training is current for the desired month.

On 1/25/2016 the unfilled cells should turn yellow indicating a 7 day window to expiration

on 2/1/2016 the unfilled celled including the previous yellow ones will automatically turn red indicating the training the the previous month was not completed.

Example Worksheet.jpg

Please advise further. You help is greatly appreciated. tks.

[FDibbins]

OK my bad, I must have had a senior moment. Let me take another look.

I did see that your 1st rule...
="AND(ISNUMBER($C33),$C33-TODAY()<=1)"
is wrapped in "" you need to remove those...
=AND(ISNUMBER($C33),$C33-TODAY()<=1)

edit: OK wasn't a senior moment, I copied the dates in column H to column C - the cells in column H did not have any CF