Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-06-2016, 01:53 PM
wmedjaxnjr wmedjaxnjr is offline Need help with using traffic lights in one cell based on date value in a different cell Windows 10 Need help with using traffic lights in one cell based on date value in a different cell Office 2013
Novice
Need help with using traffic lights in one cell based on date value in a different cell
 
Join Date: Apr 2016
Posts: 2
wmedjaxnjr is on a distinguished road
Default Need help with using traffic lights in one cell based on date value in a different cell

So, I am trying to use the traffic lights to help with something I am working on in Excel. What I need is the following:



Based on the date in A1 (for example), I need the :
green traffic light if 30 days out from today (the current date)
yellow traffic light if between 15 and 29 days out from today (the current date)
red traffic light if between 1 and 15 days out from today (the current date)
black traffic light if greater than 30 days out from today (the current date)

So, if today is 4/5/2016 and the date in column A1 is 30 days from today the stop light should be green. Likewise, if the date in column A1 is 31 and greater days from today, the stop light should be black and so on for the rest.

Anybody out there who can help me figure this out?
Reply With Quote
  #2  
Old 04-09-2016, 04:22 PM
BobBridges's Avatar
BobBridges BobBridges is offline Need help with using traffic lights in one cell based on date value in a different cell Windows 7 64bit Need help with using traffic lights in one cell based on date value in a different cell Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

Sounds to me as though you have most of it already figured out. I gather you already know where to find the traffic lights, and you know which cell is to provide the data. What are you missing?

Maybe you should explain what you've done so far, and where you get stopped. Oh, and what version of Excel are you using?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help with using traffic lights in one cell based on date value in a different cell Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to? bharathkumarst Excel 7 10-13-2014 10:25 AM
Need help with using traffic lights in one cell based on date value in a different cell Conditional formatting question based on cell date Cosmo Excel 2 04-08-2013 12:12 PM
Make table cell active add date count date MelHerndon Word VBA 3 01-21-2013 04:23 PM
Change formula cell range based on cell value Scoth Excel 4 10-25-2012 07:51 AM
How can I make a cell color RED under the Today's date cell? Learner7 Excel 2 07-08-2010 12:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:54 PM.


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