LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 2
Exclamation Changing the color of a cell in excel based on due date

Hi,

I am working on a spreadsheet at the moment for my boss where I need to make the cell change color due to VISA's expiry dates

For example if a VISA is still valid the cell will be green
if the VISA is due to expire in 6 months the cell will be orange
if the VISA is due to expire in 3 months the cell will be red

I am working in Microsoft Excel 2010.

Help please!!!!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing Cell Color Based on Value DisMusBeDaPlaz Excel Worksheet Functions 2 December 31st 09 04:55 AM
Changing background color based on different cell djarcadian Excel Discussion (Misc queries) 3 August 10th 06 10:44 PM
Changing color of single bar based on x-axis date value [email protected] Charts and Charting in Excel 2 August 4th 06 05:17 PM
Changing a cell color based on date entry ... T. Denford Excel Programming 6 April 14th 05 12:16 AM
Changing cell color based on its value spolk[_8_] Excel Programming 9 June 1st 04 08:24 AM


All times are GMT +1. The time now is 11:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"