Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm finding it difficult with conditional formatting matching the month for
=today() in cell b2 for example. the purpose is to match the month for a date ranging from d15:d24 and then highlight if the month matches. Any ideas? ive been working on this for 3 days now. thanks. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
Select your entire range D15:D24 In Excel versions 2003 and earlier Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =MONTH(B$2)=MONTH(D15) Click the Format button Select the desired style(s) OK out In Excel 2007 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format Enter this formula in the box below: =MONTH(B$2)=MONTH(D15) Click the Format button Select the desired style(s) OK out If there might be empty cells in your range D15:D24, or if B2 might be empty, then use this formula: =AND(B$2<"",D15<"",MONTH(B$2)=MONTH(D15)) -- Biff Microsoft Excel MVP "yuen" wrote in message ... I'm finding it difficult with conditional formatting matching the month for =today() in cell b2 for example. the purpose is to match the month for a date ranging from d15:d24 and then highlight if the month matches. Any ideas? ive been working on this for 3 days now. thanks. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can apply the CF directly w/o referencing
Select D15:D24 (with D15 active), then apply CF using Formula Is: =AND(ISNUMBER(D15),MONTH(D15)=MONTH(TODAY())) Format to taste OK out If the above doesn't work, that means the dates in D15:D24 aren't real dates. Select the range of "dates", convert it all at one go by clicking Data Text to Columns. Click NextNext. In step 3 of the wiz., check "Date", then choose the appropriate format from the droplist, eg: DMY. Click Finish. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:365 Subscribers:65 xdemechanik --- "yuen" wrote: I'm finding it difficult with conditional formatting matching the month for =today() in cell b2 for example. the purpose is to match the month for a date ranging from d15:d24 and then highlight if the month matches. Any ideas? ive been working on this for 3 days now. thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
partial word match for conditional formatting | Excel Worksheet Functions | |||
Conditional Formatting to match cell values | Excel Worksheet Functions | |||
Complicated conditional formatting if numbers match across a data set..How? | Excel Worksheet Functions | |||
Complicated conditional formatting if numbers match across a data set..How? | Excel Discussion (Misc queries) | |||
Conditional Formatting based on month name | Excel Discussion (Misc queries) |