Thread: I SEE NO VB CODE AND YET IT HIGHLIGHTS SAT N SUNDAYS. ANYONE INTERESTED TO FIND OUT HOW IT IS DONE.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph David Biddulph is offline
external usenet poster
  
Posts: 620
Default I SEE NO VB CODE AND YET IT HIGHLIGHTS SAT N SUNDAYS. ANYONE INTERESTED TO FIND OUT HOW IT IS DONE.
Conditional formatting?
--
David Biddulph

"CAPTGNVR" wrote in message
oups.com...
DEAR ALL
I came across this file which is used for marking the overtime for the
crew. On checking found no VB code nothing and yet on entering month
name it highlights the saturdays and sundays.

I looked into the project, modules and 'worksheet selection change' -
all are blank.

So where else i turn to nowadays otherthan this forum. Pls solve my
curiosity to know how this was done. The file is about 17kb zipped
and will send it on your request.



Reply With QuoteReply With Quote