Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Format cells dependent on given dates Format cells dependent on given dates
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-04-2016, 07:03 AM
fizzwolf fizzwolf is offline Format cells dependent on given dates Windows 10 Format cells dependent on given dates Office 2013
Novice
Format cells dependent on given dates 		 
Join Date: May 2016
Posts: 1
fizzwolf is on a distinguished road
Default Format cells dependent on given dates

How do I highlight the cells that correspond to the dates from and to in columns E and F given the calendar dates above.
Attached Files
File Type: xlsx Works Schedule.xlsx (16.1 KB, 9 views)
Reply With Quote
  #2  
Old 05-04-2016, 09:21 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Format cells dependent on given dates Windows 7 64bit Format cells dependent on given dates Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default
Hi
Before going any further, I would suggest getting rid of the merged cells which are nothing but trouble.

Then amend your example showing desired results
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Display cells dependent on option buttons inq80 Excel 0 09-01-2014 03:40 PM
Date Format: how to output dates that are not US? tinfanide Word VBA 0 10-28-2013 03:30 AM
Merging and Shading Cells based on Dates stockers Excel Programming 0 03-07-2013 02:32 PM
Format cells dependent on given dates How-TO format cells (FILL) by comparing cells zanat0s Excel 1 07-03-2012 04:27 AM
Auditing Dependent Cells WildBill Excel 2 09-07-2011 10:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:29 PM.

Contact Us - Privacy Statement - Top

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