Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 3rd 09, 12:41 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 51
Default Hightlight date range

I have a worksheet that has dates in cells B2 through B171. I want to
highlight cells from a date that is in cell F4 + 180 days. I want to be able
to change the date in F4 and the dates in B2:B171 to highlight accordingly.
Please help. Thanks

  #2   Report Post  
Old June 3rd 09, 12:53 AM posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 9,221
Default Hightlight date range

Select the range B2:B171 (with B2 active),
apply CF using Formula Is:
=AND($F$4<"",B2-$F$4=180)
Fine tune the "=" bit to suit, if necessary ..

Voila? Click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"Derek" wrote:
I have a worksheet that has dates in cells B2 through B171. I want to
highlight cells from a date that is in cell F4 + 180 days. I want to be able
to change the date in F4 and the dates in B2:B171 to highlight accordingly.
Please help. Thanks

  #3   Report Post  
Old June 3rd 09, 01:03 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 3,572
Default Hightlight date range

Select B2 to B171, and from the Menu Bar:
<Format <Conditional Format

Change "Cell Value Is" to "Formula Is",
AND, if I understand you correctly, enter this formula:

=AND(B2<"",B2=$F$4+180,$F$4<"")

Click on <Format, and choose a Pattern to your liking,
then <OK <OK.

If I misunderstood your request, try this formula instead:

=AND(B2<"",B2<=$F$4+180,$F$4<"")


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Derek" wrote in message
...
I have a worksheet that has dates in cells B2 through B171. I want to
highlight cells from a date that is in cell F4 + 180 days. I want to be
able
to change the date in F4 and the dates in B2:B171 to highlight
accordingly.
Please help. Thanks





Reply
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
Sum If range of dates date range, sum totals Stilmovin Excel Worksheet Functions 7 December 16th 08 05:49 PM
condtional format - hightlight max results Nadine Excel Discussion (Misc queries) 4 July 10th 08 04:48 AM
HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL Chopper Excel Worksheet Functions 3 August 7th 07 03:58 AM
Conditional Formatting (Hightlight row based on one condition) Jamesy Excel Discussion (Misc queries) 3 November 16th 06 04:02 PM
How to count dates within a certain range in a column with mutiple date range entries Krisjhn Excel Worksheet Functions 2 September 1st 05 01:59 PM


All times are GMT +1. The time now is 06:13 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017