Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-08-2014, 09:22 AM
EC37 EC37 is offline Conditional Formatting - color only dates contained in a range Windows 7 64bit Conditional Formatting - color only dates contained in a range Office 2010 64bit
Advanced Beginner
Conditional Formatting - color only dates contained in a range
 
Join Date: May 2014
Location: Waltham, MA
Posts: 56
EC37 is on a distinguished road
Default Conditional Formatting - color only dates contained in a range

Info:
Column A contains an ID#
Column B contains a circle (Font: Wingdings, Letter: l)
Column C contains a Start Date
Column D contains a Finish Date
Cell: S2 =TODAY()


Cell: T2 is 10
Cell: U2 =WORKDAY(S2,T2)

I am trying to set a formula for conditional formatting to do the following:


IF [the date contained in column D] falls between S2 AND U2 THEN color the cells in column B yellow

In otherwords, if a date falls between now and the next 10 business days, I want to color the cell in column B the color yellow.

I currently have a conditional format formula set to color column B red if the date in column I is <TODAY().

I tried to set up the formatting for YELLOW to be:
:Format only cells that contain
Cell Value - Between - =D2>S2 and =D2<U2
Format Font - yellow

But it doesn't seem to work.

Any help would be appreciated.

Thanks,
E
Reply With Quote
  #2  
Old 07-08-2014, 12:51 PM
whatsup whatsup is offline Conditional Formatting - color only dates contained in a range Windows 7 64bit Conditional Formatting - color only dates contained in a range Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi

Use the formula section of cond. formatting:
=AND(D2>S2,D2<U2)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting - color only dates contained in a range Conditional Formatting - past due dates namedujour Excel 1 06-27-2014 04:16 PM
Conditional Formatting - color only dates contained in a range Conditional Formatting with Graded Color Scale Texas_Steve Excel 4 09-25-2013 11:44 AM
Conditional Formatting with Dates namedujour Excel 1 02-21-2013 03:42 AM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM

Other Forums: Access Forums - Senior Forums

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


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