Forum Discussion

Allocca77's avatar
Allocca77
Copper Contributor
Mar 06, 2024

Conditional Formatting Question

I'm having a lot of trouble with creating a rule that appears to be simple. I have a row of sequential numbers in row 5 and months (starting in 2023) in row 7. In J1, I have MONTH(TODAY())+12. Using this, March displays as 15. I've successfully made a rule that turns the current month in row 7 green.

 

In D1, I have =J1-6, which returns 9. I'm trying to write a formatting rule that says any column below the number in D1 should be filled in with grey, and conversely one that turns anything greater than the current month (J1) as a light grey.

 

However each time I try I get either nothing grey or everything grey.

 

Not sure why I can't attach .xlsx files in an Excel forum, so here's a google drive link to it: https://docs.google.com/spreadsheets/d/1azYq2E40FGRVyPRXR5Cyg31Z8KUn5--m/edit?usp=sharing&ouid=118377819205801127079&rtpof=true&sd=true

Resources