Avatar of UncleVirus
UncleVirusFlag for United Kingdom of Great Britain and Northern Ireland asked on

Excel 2013 Conditional Formatting - Domain Renewal Spreadsheet

I have been scratching my head and searching the internet for the past 3 hours on how exactly to achieve what I want! I'm almost tempted to do this by hand but I want to automate it if possible!

I've created a spreadsheet for all the domains under our control and I want the date to go orange if it's due for renewal in the next 3 months, green if it's anything further in the future.

Here's a snapshot of what I've got so far. Please disrgard any colour/formatting visible. I've stripped the domains for confidentiality reasons but the first two columns are currently fully populated. I'd like the entire row to be formatted with the colouring as it shows currently.

Excel Spreadsheet
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment

8/22/2022 - Mon
barry houdini

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

Barry, you Sir, are a legend!

The correct method and feeding the correct formulae into the Conditional Formatting box was where I was tripping up. Seeing your visual example enabled me to adapt my spreadsheet accordingly in no time at all.

Thank you very much :-)
barry houdini

>Barry, you Sir, are a legend!

Thanks for the compliment UncleVirus (is there an AuntVirus?), but at EE "Legend" is a term specifically applied to somebody with 100 million points (there are currently no legends as nobody has more than 39 million points).

....still, only another 95,214,925 to go!

regards, barry

One point at a time eh? I have another conundrum on the same spreadsheet involving adding a button/macro to increment the date by 1 year if you fancy another challenge ;-) I'll raise a new question for that though! :-)
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.