LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default Cell color change based on Date

What formula would I used to change a range of cells a different color based on the current date?

For example if I have a date of 1/1/2015 in a cell can I change adjoining cells a different color based on the current date?

Last edited by Rocky Williams : December 29th 14 at 06:28 PM
 
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
Change Color of Cell based on Date and today's date. SammiJojo412 Excel Worksheet Functions 1 July 23rd 12 10:18 PM
change fill color of a range of cells based on color of a cell? DarMelNel Excel Programming 0 March 2nd 06 06:35 PM
cell color change based on due date MINAL ZUNKE New Users to Excel 2 June 30th 05 09:24 PM
Change cell color based on date RRP333 Excel Programming 8 March 2nd 05 05:44 AM
Browse Forms Controls and change TextBox color based on cell color StefanW Excel Programming 2 November 21st 04 07:06 PM


All times are GMT +1. The time now is 07:26 AM.

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

About Us

"It's about Microsoft Excel"