LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Geo Geo is offline
external usenet poster
 
Posts: 66
Default Check date range on three sheets?

How can I get a date to turn red if it falls within a date range in two other
sheets.
ie:
Leave dates for three person are inserted in their own sheets. If one of
them chooses to have leave dates that conflicts with another, is there a way
if the date to turn red?
 
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
How to check if a date falls within a range(2 cells: Start/End Dat MarcusMac Excel Worksheet Functions 4 July 30th 08 04:21 PM
Check Date Range and Multiply Stock Qty Jon[_6_] Excel Worksheet Functions 2 January 18th 08 11:52 AM
check whether a date falls in a range RGB Excel Discussion (Misc queries) 1 May 19th 06 02:15 PM
how to check if date falls within range Bharat Saboo Excel Worksheet Functions 4 December 30th 05 10:31 AM
Can I check if a date falls between a range then sum other # if tr clovins1 Excel Worksheet Functions 2 October 9th 05 02:14 AM


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