Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-18-2022, 01:30 AM
stu_c stu_c is offline Date Conditional Formatting Windows 10 Date Conditional Formatting Office 2016
Novice
Date Conditional Formatting
 
Join Date: Dec 2013
Posts: 20
stu_c is on a distinguished road
Default Date Conditional Formatting


Hi all,
I want to be able to do a spreadsheet for peoples training, some training valid for longer times which is shown in the file attached.

what I want to be able to do is add the amount of years valid for onto the last date date taken and then show either show the following
White - 1 Year left or more
Green - 6 Months Left
Orange - 3 Months Left
Red - 1 Month Or Less

I was thinking of having another column showing the date due (Date Taken + Row 2 in years) then hide that column and do the conditional formatting from that but didn't know if there was a better way?

Problem I have is I don't know the formula to add the row 2 onto the years and also in conditional formatting how you would do for example (B4 + B2 = <Today()

I do not know if I am just over thinking it, been a very long time since doing Excel formulas :/
Attached Files
File Type: xlsx Training.xlsx (9.9 KB, 8 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting a row based on date cwkotch Excel 1 08-28-2021 10:14 PM
Conditional Formatting based on date teza2k06 Excel 2 11-27-2018 09:55 AM
Date Conditional Formatting Conditional Formatting based on dynamic Date Modifier1000 Excel 2 09-12-2014 08:53 AM
Date Conditional Formatting Date Conditional Formatting teza2k06 Excel 1 08-09-2014 09:58 AM
Date Conditional Formatting Conditional formatting question based on cell date Cosmo Excel 2 04-08-2013 12:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft