Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional format date range
Ok so I have a sheet containing dates in cells B2 through B171. I want the
cells to highlight based on a date that is in cell F4. I want it to hightlight all the dates from the date in F4 + 180 days. That way when I change the date in F4 it will change the highlighted dates in B2:B171. Please Help !!! Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional format date range
Derek
Please don't multi-post ... See responses in .newusers Here's mine as posted the 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: Ok so I have a sheet containing dates in cells B2 through B171. I want the cells to highlight based on a date that is in cell F4. I want it to hightlight all the dates from the date in F4 + 180 days. That way when I change the date in F4 it will change the highlighted dates in B2:B171. Please Help !!! Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional format date range
Hi,
Highlight B2:B171 or whatever, If you always enter a date in F4 then choose Format, Conditional Formatting, Formula is and enter the formula =B2=F$4+180 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Derek" wrote: Ok so I have a sheet containing dates in cells B2 through B171. I want the cells to highlight based on a date that is in cell F4. I want it to hightlight all the dates from the date in F4 + 180 days. That way when I change the date in F4 it will change the highlighted dates in B2:B171. Please Help !!! Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format a Range Name | Excel Worksheet Functions | |||
Conditional format of range | Excel Discussion (Misc queries) | |||
Conditional Format over Date Range | Excel Discussion (Misc queries) | |||
conditional format a range | Excel Discussion (Misc queries) | |||
Conditional format IP range | Excel Discussion (Misc queries) |