Welcome to E-Goat :: The Totally Unofficial Royal Air Force Rumour Network
Join our free community to unlock a range of benefits like:
  • Post and participate in discussions.
  • Send and receive private messages with other members.
  • Respond to polls and surveys.
  • Upload and share content.
  • Gain access to exclusive features and tools.
Join 7.5K others today

Conditional Formatting in Excel

  • Following weeks of work, the E-GOAT team are delighted to present to you a new look to the forums with plenty of new features. Take a look around and see what you think!
Trending This Week
View More Trending
M

Mightierthan

Corporal
411
16
0
Hopefully there will be an Excel whizz out there who can help me.
I want to use Conditional Formatting for a range of cells that have to be in date format. I want to apply formatting when each date is 3 years in the past. I have tried the 'less than' and then typing varieties of "today-1095" etc, but to no avail.
Can anyone advise on the correct formula? Cheers
 
I can't remember exactly but you have to do something with the date to convert to a number do the sum and then convert back. I'm racking my brains at the mo Excel treats dates as a finite figure when its manipulating them and its this feature that you use. Will get back to you.
 
You must log in or register to reply here.
Back
Top