Thread: Code to conditional format all black after date specified in code?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
wx4usa wx4usa is offline
external usenet poster
  
Posts: 122
Default Code to conditional format all black after date specified in code?
I have a date in cell A100 sheet 1

Can anyone provide a code that will conditionally format an entire
sheet (sheet2) to black fill and font if now() is greater than date in
cell A1?

Or perhaps change sheet 2 to Very Hidden.
Reply With QuoteReply With Quote