LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
lau lau is offline
external usenet poster
 
Posts: 2
Default Conditional Formats Date Based

I need to format a row in a workbook so that the cells in the range change
color based on a date on another workbook. It needs to be formatted so that
when a certain date ie 12/1/09 is reached, the color changes to green, but is
yellow or red if it's later than 12/1/09 like 3/1/09 depending on what's
entered in the worksheet.
 
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
Conditional Formating Based on Formats Instead of Values Abby Dabby Doo Excel Discussion (Misc queries) 1 May 15th 08 01:18 AM
Conditional Formating based on Date Flcnmech Excel Worksheet Functions 1 February 14th 08 08:21 PM
conditional formats based on If Mike Excel Worksheet Functions 7 November 16th 06 01:05 PM
Conditional Formating Based on Date Roy Excel Discussion (Misc queries) 5 June 7th 06 04:49 PM
Copy Color Formats Based On Column Date Values Naji Excel Discussion (Misc queries) 0 January 11th 06 09:06 PM


All times are GMT +1. The time now is 01:14 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"