Link to home
Start Free TrialLog in
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.

User generated image
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of UncleVirus


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, 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! :-)