Thread: Is there a formula to AUTOMATICALLY highlight a specific month
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JMKCT JMKCT is offline
external usenet poster
  
Posts: 1
Default Is there a formula to AUTOMATICALLY highlight a specific month

Try inputting a formula in the conditional formatting =month(a1)=3
If it works copy and paste formatting only to relevant cells

--
JMKC
-----------------------------------------------------------------------
JMKCT's Profile: http://www.excelforum.com/member.php...fo&userid=2939
View this thread: http://www.excelforum.com/showthread.php?threadid=49104

Reply With QuoteReply With Quote