Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum If range of dates date range, sum totals | Excel Worksheet Functions | |||
condtional format - hightlight max results | Excel Discussion (Misc queries) | |||
HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL | Excel Worksheet Functions | |||
Conditional Formatting (Hightlight row based on one condition) | Excel Discussion (Misc queries) | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |