Conditional formatting not working on all cells

[nmbell]

I have conditional formatting to help visually identify when certain licenses will expire. However, the formatting seems to be working except in cell I6 (the cells containing the date 2/29/2023 in the expires after 3 years column) and I cannot figure out why. Any ideas what is happening would be helpful.

 

[6StringJazzer]

The data in that cell is text, not a date. I can tell because there is a leading 0 but none of your other dates do this. Retype 2/29/2023 into the cell.

P.S. If you show a screen shot instead of using L2BB, please show column and row headers so we can confirm what cells we are looking at.

 

[Candyman8019]

Also, It doesn't look like I6 isn't included in any of the ranges you specified in your rules.

 

[nmbell]

I retyped the date and confirmed that cell is formatted as a date. That did not correct it to now highlight. I apologize, but I don't know what a code tag is or anything regarding a vba button.

 

[nmbell]

Also, It doesn't look like I6 isn't included in any of the ranges you specified in your rules.

Would you be able to tell me what to update so those cells are included?

 

[Candyman8019]

What is the complete range that you want this formatting applicable to?

 

[nmbell]

Columns C4 to H4 and currently down through row 43

 

[6StringJazzer]

Also, It doesn't look like I6 isn't included in any of the ranges you specified in your rules.

I missed that. Here is where to fix it. Change

$G$4:$I$5,$G$7:$I$43

to

$G$4:$I$43

There may be some other cleanup needed in these ranges but that will fix the I6 problem.