View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vane0326
 
Posts: n/a
Default How do I use conditional formatting to hilite weekend dates where.


See if this works.



=WEEKDAY(A1,2)5


--
vane0326
------------------------------------------------------------------------
vane0326's Profile: http://www.excelforum.com/member.php...o&userid=14731
View this thread: http://www.excelforum.com/showthread...hreadid=533973