Highlite the date cells if criteria as week number

[salim]

Hi Dears
I have a table with different dates in cells A2:C500 and D1 is my criteria with week number, how do highlite the date cells if the week number match

[6StringJazzer]

Use conditional formatting and create a rule that says

=WEEKNUM(A2,1)=$D$1

and apply it to A2:C500

This assumes that your week starts on Sunday. If not, look up the appropriate value to use for the second argument.

[salim]

Thanks for the support. Column A2:C500 scheduled different dates for staff training. the criteria (week number) will be changed to different weeks, so the dates which is matching with week number should be highlighted, could you please look on this

[salim]

Thanks Jazzar
I selected Saturday (16) from the list, works fine, thanks lot

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.